Revision 12286
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/inputs/bien2_traits/validations.sql | ||
|---|---|---|
| 16 | 16 |
-- |
| 17 | 17 |
|
| 18 | 18 |
CREATE VIEW _traits_01_count_records AS |
| 19 |
SELECT count(*) AS totalrecords
|
|
| 19 |
SELECT count(*) AS "totalRecords"
|
|
| 20 | 20 |
FROM "TraitObservation" |
| 21 | 21 |
WHERE (((("TraitObservation"."taxonName" IS NOT NULL) AND ("TraitObservation"."taxonName" <> ''::text)) AND ("TraitObservation"."measurementName" IS NOT NULL)) AND ("TraitObservation"."measurementName" <> ''::text));
|
| 22 | 22 |
|
Also available in: Unified diff
bugfix: inputs/bien2_traits/validations.sql: _traits_01_count_records: changed column names to match public_validations._traits_01_count_records