Revision 6860
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 3645 | 3645 |
-- |
| 3646 | 3646 |
|
| 3647 | 3647 |
CREATE VIEW provider_view AS |
| 3648 |
(SELECT source.shortname AS name, source.sourcetype, source.observationtype FROM source ORDER BY source.sourcetype DESC, source.shortname) UNION ALL (SELECT sourcename.name, 'herbarium'::sourcetype AS sourcetype, 'specimen'::observationtype AS observationtype FROM sourcename WHERE (sourcename.matched_source_id IS NULL) ORDER BY sourcename.name); |
|
| 3648 |
(SELECT source.shortname AS name, source.sourcetype, source.observationtype FROM source ORDER BY source.sourcetype DESC NULLS LAST, source.shortname) UNION ALL (SELECT sourcename.name, 'herbarium'::sourcetype AS sourcetype, 'specimen'::observationtype AS observationtype FROM sourcename WHERE (sourcename.matched_source_id IS NULL) ORDER BY sourcename.name);
|
|
| 3649 | 3649 |
|
| 3650 | 3650 |
|
| 3651 | 3651 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: provider_view: Sort NULL sourcetype last