Project

General

Profile

« Previous | Next » 

Revision 10947

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.

View differences:

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