Moving array aggregates into Pg-database.sql

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1599 4979c152-3d1c-0410-bac9-87ea11338e46

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;