Revision 10947
Added by Aaron Marcuse-Kubitza about 11 years ago
postprocess.sql | ||
---|---|---|
1 | 1 |
SELECT util.search_path_append('util'); |
2 | 2 |
|
3 | 3 |
SELECT force_update_view('"occurrence_all"', $$ |
4 |
SELECT "*TREE-row_num" AS "occurrence_all-row_num", *
|
|
4 |
SELECT "*TREE--row_num" AS "occurrence_all--row_num", *
|
|
5 | 5 |
/* directional joins ensure that the PostgreSQL query planner always joins |
6 | 6 |
starting with the TREE table */ |
7 | 7 |
FROM "TREE" |
... | ... | |
16 | 16 |
NATURAL LEFT JOIN "REF_RESEARCH_STATION" |
17 | 17 |
$$); |
18 | 18 |
|
19 |
SELECT mk_subset_by_row_num_func('"occurrence_all"', 'occurrence_all-row_num'); |
|
19 |
SELECT mk_subset_by_row_num_func('"occurrence_all"', 'occurrence_all--row_num'); |
Also available in: Unified diff
inputs/FIA/*/map.csv: use -- to separate the table and column name instead of - , to conform with the u-name format (wiki.vegpath.org/u-name#format), which works even when only one of _- can be used in the name. -s are needed in this case to linewrap the column on a separate line as the table in phpPgAdmin.