SF.net SVN: ledger-smb: [1599] trunk/sql/Pg-database.sql

[..hidden..]

Revision: 1599
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=1599&view=rev
Author:   einhverfr
Date:     2007-09-14 09:39:01 -0700 (Fri, 14 Sep 2007)

Log Message:
-----------
Moving array aggregates into Pg-database.sql

Modified Paths:
--------------
    trunk/sql/Pg-database.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-09-14 16:37:42 UTC (rev 1598)
+++ trunk/sql/Pg-database.sql	2007-09-14 16:39:01 UTC (rev 1599)
@@ -2665,5 +2665,19 @@
 --
 -- 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;


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.