Revision 12367
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/inputs/bien2_traits/validations.sql | ||
|---|---|---|
| 90 | 90 |
|
| 91 | 91 |
|
| 92 | 92 |
-- |
| 93 |
-- Name: _traits_08_taxonname_trait_and_value_for_first_5000_records; Type: VIEW; Schema: bien2_traits; Owner: -
|
|
| 93 |
-- Name: _traits_08_taxonname_trait_and_value; Type: VIEW; Schema: bien2_traits; Owner: - |
|
| 94 | 94 |
-- |
| 95 | 95 |
|
| 96 |
CREATE VIEW _traits_08_taxonname_trait_and_value_for_first_5000_records AS
|
|
| 96 |
CREATE VIEW _traits_08_taxonname_trait_and_value AS |
|
| 97 | 97 |
SELECT btrim(concat_ws(' '::text, ifnull("TraitObservation"."taxonName", ''::text), ifnull("TraitObservation"."scientificNameAuthorship", ''::text))) AS taxonwithauthor,
|
| 98 | 98 |
"TraitObservation"."measurementName" AS trait, |
| 99 | 99 |
"TraitObservation"."measurementValue" AS value |
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 3814 | 3814 |
|
| 3815 | 3815 |
|
| 3816 | 3816 |
-- |
| 3817 |
-- Name: _traits_08_taxonname_trait_and_value_for_first_5000_records; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 3817 |
-- Name: _traits_08_taxonname_trait_and_value; Type: VIEW; Schema: public_validations; Owner: - |
|
| 3818 | 3818 |
-- |
| 3819 | 3819 |
|
| 3820 | 3820 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 6196 | 6196 |
|
| 6197 | 6197 |
|
| 6198 | 6198 |
-- |
| 6199 |
-- Name: _traits_08_taxonname_trait_and_value_for_first_5000_records; Type: VIEW; Schema: public_validations; Owner: -
|
|
| 6199 |
-- Name: _traits_08_taxonname_trait_and_value; Type: VIEW; Schema: public_validations; Owner: - |
|
| 6200 | 6200 |
-- |
| 6201 | 6201 |
|
| 6202 |
CREATE VIEW _traits_08_taxonname_trait_and_value_for_first_5000_records AS
|
|
| 6202 |
CREATE VIEW _traits_08_taxonname_trait_and_value AS |
|
| 6203 | 6203 |
SELECT concat_ws(' '::text, taxonverbatim.taxonname, taxonverbatim.author) AS taxonwithauthor,
|
| 6204 | 6204 |
trait.name AS trait, |
| 6205 | 6205 |
trait.value |
Also available in: Unified diff
fix: schemas/vegbien.sql: _traits_08_taxonname_trait_and_value_for_first_5000_records: renamed to _traits_08_taxonname_trait_and_value because this actually includes all the records, not just the first 5000. this uses the new public_validations.rename_query_view() to rename all associated tables and views, including handling truncated names.