summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/Pg-database.sql14
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;