Revision 12966
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 8164 | 8164 |
|
| 8165 | 8165 |
CREATE VIEW _specimens_01_count_of_total_records_specimens_in_source_db AS |
| 8166 | 8166 |
SELECT count(*) AS "totalSpecimenRecords" |
| 8167 |
FROM public.location
|
|
| 8168 |
WHERE (location.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname));
|
|
| 8167 |
FROM public.taxonoccurrence
|
|
| 8168 |
WHERE (taxonoccurrence.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname));
|
|
| 8169 | 8169 |
|
| 8170 | 8170 |
|
| 8171 | 8171 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: updated _specimens_01_count_of_total_records_specimens_in_source_db