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               ("REF_RESEARCH_STATION"
NATURAL RIGHT JOIN ("REF_UNIT"
NATURAL RIGHT JOIN ("COUNTY"
NATURAL RIGHT JOIN ("PLOT"
NATURAL RIGHT JOIN ("COND"
	NATURAL LEFT JOIN "REF_HABTYP_DESCRIPTION"
NATURAL RIGHT JOIN ("SUBPLOT"
NATURAL RIGHT JOIN ("TREE"
	NATURAL LEFT JOIN "REF_SPECIES"
	NATURAL LEFT JOIN "REF_PLANT_DICTIONARY"
)))))))
$$);

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