From ad7dff95ec2488d6c982abb07a0b42c6f643cbc2 Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Fri, 14 Sep 2007 16:39:01 +0000
Subject: 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
---
 sql/Pg-database.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

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;
-- 
cgit v1.2.3