Revision 13090
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 8989 | 8989 |
WHERE (taxonoccurrence.source_id = ( SELECT public.source_by_shortname(("current_schema"())::text) AS source_by_shortname))
|
| 8990 | 8990 |
GROUP BY ( SELECT party.fullname |
| 8991 | 8991 |
FROM public.party |
| 8992 |
WHERE (party.party_id = taxonoccurrence.collector_id)), specimenreplicate.collectionnumber, aggregateoccurrence.collectiondate
|
|
| 8992 |
WHERE (party.party_id = taxonoccurrence.collector_id)), specimenreplicate.collectionnumber, (aggregateoccurrence.collectiondate)::text
|
|
| 8993 | 8993 |
ORDER BY ( SELECT party.fullname |
| 8994 | 8994 |
FROM public.party |
| 8995 |
WHERE (party.party_id = taxonoccurrence.collector_id)), specimenreplicate.collectionnumber, aggregateoccurrence.collectiondate;
|
|
| 8995 |
WHERE (party.party_id = taxonoccurrence.collector_id)), specimenreplicate.collectionnumber, (aggregateoccurrence.collectiondate)::text;
|
|
| 8996 | 8996 |
|
| 8997 | 8997 |
|
| 8998 | 8998 |
-- |
Also available in: Unified diff
fix: schemas/vegbien.sql: _specimens_12_distinct_collector_name_collect_num_date_w_count: dateCollected: also need to convert to text in GROUP BY/ORDER BY