Revision 12322
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 6053 | 6053 |
FROM (public.trait |
| 6054 | 6054 |
JOIN public.taxonoccurrence USING (taxonoccurrence_id)) |
| 6055 | 6055 |
WHERE (taxonoccurrence.source_id = public.source_by_shortname(("current_schema"())::text))
|
| 6056 |
ORDER BY trait.name, trait.value, trait.units |
|
| 6057 |
LIMIT 5000; |
|
| 6056 |
ORDER BY trait.name, trait.value, trait.units; |
|
| 6058 | 6057 |
|
| 6059 | 6058 |
|
| 6060 | 6059 |
-- |
| ... | ... | |
| 6069 | 6068 |
JOIN public.taxondetermination ON (((taxondetermination.taxonverbatim_id = taxonverbatim.taxonverbatim_id) AND taxondetermination.iscurrent))) |
| 6070 | 6069 |
JOIN public.trait USING (taxonoccurrence_id)) |
| 6071 | 6070 |
WHERE (taxonverbatim.source_id = public.source_by_shortname(("current_schema"())::text))
|
| 6072 |
ORDER BY taxonverbatim.taxonname |
|
| 6073 |
LIMIT 5000; |
|
| 6071 |
ORDER BY taxonverbatim.taxonname; |
|
| 6074 | 6072 |
|
| 6075 | 6073 |
|
| 6076 | 6074 |
SET search_path = public, pg_catalog; |
Also available in: Unified diff
fix: schemas/vegbien.sql: _traits_07_trait_value_and_units, _traits_08_taxonname_trait_and_value_for_first_5000_records: removed LIMIT to match the input queries