Project

General

Profile

« Previous | Next » 

Revision 12909

Added by Aaron Marcuse-Kubitza almost 11 years ago

validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql: translated SQL to Postgres

View differences:

trunk/validation/aggregating/specimens/NY/qualitative_validations_source_db_NYBG.VegCore.sql
129 129 
(
130 130 
SELECT COUNT(*)
131 131 
FROM "Ecatalog_all"
132 
WHERE "decimalLatitude" REGEXP '^(-|\\+){0,1}([0-9]+\\.[0-9]*|[0-9]*\\.[0-9]+|[0-9]+)$'
132 
WHERE "decimalLatitude" ~ '^(-|\\+){0,1}([0-9]+\\.[0-9]*|[0-9]*\\.[0-9]+|[0-9]+)$'
133 133 
) AS "decimalLats",
134 134 
(
135 135 
SELECT COUNT(*)
......
139 139 
(
140 140 
SELECT COUNT(*)
141 141 
FROM "Ecatalog_all"
142 
WHERE "decimalLongitude" REGEXP '^(-|\\+){0,1}([0-9]+\\.[0-9]*|[0-9]*\\.[0-9]+|[0-9]+)$'
142 
WHERE "decimalLongitude" ~ '^(-|\\+){0,1}([0-9]+\\.[0-9]*|[0-9]*\\.[0-9]+|[0-9]+)$'
143 143 
) AS "decimalLongs";
144 144 
COMMENT ON VIEW _specimens_13_count_of_all_verbatim_and_decimal_lat_long
145 145 
  IS '

Also available in: Unified diff