Revision 14309
Added by Aaron Marcuse-Kubitza over 10 years ago
| util.sql | ||
|---|---|---|
| 2111 | 2111 |
RETURNS trigger AS |
| 2112 | 2112 |
$BODY1$ |
| 2113 | 2113 |
BEGIN |
| 2114 |
-- clear derived cols so old values won't be used in calculations |
|
| 2114 | 2115 |
$$||( |
| 2115 | 2116 |
SELECT string_agg( |
| 2117 |
$$ new.$$||quote_ident((derived_col_def).col.name)||$$ = NULL; |
|
| 2118 |
$$, '') |
|
| 2119 |
FROM util.derived_col_defs(table_) derived_col_def |
|
| 2120 |
)|| |
|
| 2121 |
$$ |
|
| 2122 |
-- populate derived cols |
|
| 2123 |
$$||( |
|
| 2124 |
SELECT string_agg( |
|
| 2116 | 2125 |
$$ new.$$||quote_ident((derived_col_def).col.name)||$$ = (SELECT $$||(derived_col_def).expr||$$ FROM (SELECT new.*) new); |
| 2117 | 2126 |
$$, '') |
| 2118 | 2127 |
FROM util.derived_col_defs(table_) derived_col_def |
Also available in: Unified diff
bugfix: schemas/util.sql: derived_cols_trigger_update(): need to clear derived cols first so old values won't be used in calculations