SELECT util.search_path_append('util');

SELECT force_update_view(:table_str, $$

SELECT "*TREE--row_num" AS "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(:table_str, 'row_num');