Revision 8220
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/FIA/occurrence_all/import | ||
|---|---|---|
| 7 | 7 |
DROP VIEW IF EXISTS occurrence_all; |
| 8 | 8 |
CREATE OR REPLACE VIEW occurrence_all AS |
| 9 | 9 |
SELECT * |
| 10 |
/* directional joins needed for PostgreSQL query planner to avoid slow sorts */ |
|
| 11 | 10 |
FROM "REF_RESEARCH_STATION" |
| 12 | 11 |
NATURAL JOIN "REF_UNIT" |
| 13 | 12 |
NATURAL JOIN "COUNTY" |
Also available in: Unified diff
inputs/FIA/occurrence_all/import: Removed no longer applicable comment that directional joins are needed for PostgreSQL query planner to avoid slow sorts