diff options
-rw-r--r-- | sql/Pg-database.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index 88e0d32f..e57d0b1c 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -2665,5 +2665,19 @@ ALTER TABLE public.menu_friendly OWNER TO ledgersmb; -- -- PostgreSQL database dump complete -- +CREATE AGGREGATE as_array ( + BASETYPE = ANYELEMENT, + STYPE = ANYARRAY, + SFUNC = ARRAY_APPEND, + INITCOND = '{}' +); + +CREATE AGGREGATE compound_array ( + BASETYPE = ANYARRAY, + STYPE = ANYARRAY, + SFUNC = ARRAY_CAT, + INITCOND = '{}' +); + commit; |