Revision 14373
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 2068 | 2068 |
CREATE FUNCTION derived_cols_export(table_ regclass) RETURNS text |
| 2069 | 2069 |
LANGUAGE sql STABLE |
| 2070 | 2070 |
AS $_$ |
| 2071 |
SELECT string_agg( |
|
| 2071 |
SELECT $$ |
|
| 2072 |
-- only needed if changing the derived column order: |
|
| 2073 |
SELECT util.derived_cols_remove($$||util.quote_typed(table_)||$$); |
|
| 2074 |
|
|
| 2075 |
$$|| |
|
| 2076 |
string_agg( |
|
| 2072 | 2077 |
$$SELECT util.derived_col_update($$||util.quote_typed(def)||$$); |
| 2073 | 2078 |
$$, '') |
| 2074 | 2079 |
||$$ |
Also available in: Unified diff
bugfix: schemas/util.sql: derived_cols_export(): also need to first run util.derived_cols_remove() if changing the derived column order