Revision 8101
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/FIA/COND/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
inputs/FIA/COND/postprocess.sql: Renamed oldgrowth to COND.oldgrowth so it wouldn't be renamed by to_global_col_names()