Project

General

Profile

« Previous | Next » 

Revision 8101

inputs/FIA/COND/postprocess.sql: Renamed oldgrowth to COND.oldgrowth so it wouldn't be renamed by to_global_col_names()

View differences:

postprocess.sql
8 8
SELECT functions.rename_if_exists($$ALTER TABLE "COND" RENAME "COND.CONDID"   TO ".CONDID"  $$);
9 9

  
10 10
SELECT functions.create_if_not_exists($$
11
ALTER TABLE "COND" ADD   COLUMN oldgrowth      boolean;
12
ALTER TABLE "COND" ALTER COLUMN oldgrowth TYPE boolean USING
11
ALTER TABLE "COND" ADD   COLUMN "COND.oldgrowth"      boolean;
12
ALTER TABLE "COND" ALTER COLUMN "COND.oldgrowth" TYPE boolean USING
13 13
(
14 14
    "COND.STDAGE"::integer>80 
15 15
    AND ("COND.TRTCD1"='0' OR "COND.TRTCD1" IS NULL)

Also available in: Unified diff