Revision 11731
Added by Aaron Marcuse-Kubitza almost 11 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 3002 | 3002 |
CREATE VIEW collected_date_min AS |
| 3003 | 3003 |
SELECT analytical_stem."dateCollected" |
| 3004 | 3004 |
FROM analytical_stem |
| 3005 |
WHERE (analytical_stem."dateCollected" IS NOT NULL)
|
|
| 3005 |
WHERE ((analytical_stem."dateCollected" IS NOT NULL) AND (analytical_stem."dateCollected" <> '-infinity'::date))
|
|
| 3006 | 3006 |
ORDER BY analytical_stem."dateCollected" |
| 3007 | 3007 |
LIMIT 1; |
| 3008 | 3008 |
|
Also available in: Unified diff
bugfix: schemas/vegbien.sql: collected_date_min: exclude -infinity