Revision 12906
Added by Aaron Marcuse-Kubitza almost 11 years ago
trunk/validation/aggregating/specimens/qualitative_validations_specimens.sql | ||
---|---|---|
71 | 71 |
|
72 | 72 |
-- ------------------------------- |
73 | 73 |
-- 11. List of three standard political divisions |
74 |
-- Note: character set issues may cause mis-matches. This query is a good way to reveal |
|
75 |
-- character set issues, either in source db or in BIEN |
|
76 | 74 |
-- ------------------------------- |
77 | 75 |
CREATE OR REPLACE VIEW _specimens_11_list_of_three_standard_political_divisions AS |
78 | 76 |
; |
77 |
/* |
|
78 |
Note: character set issues may cause mis-matches. This query is a good way to reveal character set issues, either in source db or in BIEN |
|
79 |
*/ |
|
79 | 80 |
|
80 | 81 |
-- ------------------------------- |
81 | 82 |
-- 12. Check distinct Collector names + collection numbers + collection dates, |
Also available in: Unified diff
validation/aggregating/specimens/qualitative_validations_specimens.sql: moved notes to comments to after the query