SELECT util.search_path_append('util');

SELECT force_update_view('"occurrence_all"', $$

SELECT "*TREE--row_num" AS "occurrence_all--row_num", *

/* directional joins ensure that the PostgreSQL query planner always joins

starting with the TREE table */

FROM              "TREE"

NATURAL LEFT JOIN "REF_SPECIES"

NATURAL LEFT JOIN "REF_PLANT_DICTIONARY"

NATURAL LEFT JOIN "SUBPLOT"

NATURAL LEFT JOIN "COND"

NATURAL LEFT JOIN "REF_HABTYP_DESCRIPTION"

NATURAL LEFT JOIN "PLOT"

NATURAL LEFT JOIN "COUNTY"

NATURAL LEFT JOIN "REF_UNIT"

NATURAL LEFT JOIN "REF_RESEARCH_STATION"

$$);

SELECT mk_subset_by_row_num_func('"occurrence_all"', 'occurrence_all--row_num');