X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 3F5463A3B04
	for <pgsql-docs-postgresql.org@localhost.postgresql.org>;
	Mon,  1 Nov 2004 00:36:30 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 28120-09
	for <pgsql-docs-postgresql.org@localhost.postgresql.org>;
	Mon,  1 Nov 2004 00:36:19 +0000 (GMT)
Received: from fetter.org (dsl092-188-065.sfo1.dsl.speakeasy.net
	[66.92.188.65])
	by svr1.postgresql.org (Postfix) with ESMTP id DCE633A432B
	for <pgsql-docs@postgresql.org>; Mon,  1 Nov 2004 00:36:17 +0000 (GMT)
Received: from fetter.org (localhost.localdomain [127.0.0.1])
	by fetter.org (8.12.11/8.12.10) with ESMTP id iA10aFIn022002
	for <pgsql-docs@postgresql.org>; Sun, 31 Oct 2004 16:36:15 -0800
Received: (from shackle@localhost)
	by fetter.org (8.12.11/8.12.11/Submit) id iA10aEpB022001
	for pgsql-docs@postgresql.org; Sun, 31 Oct 2004 16:36:14 -0800
Date: Sun, 31 Oct 2004 16:36:14 -0800
From: David Fetter <david@fetter.org>
To: PostgreSQL Docs <pgsql-docs@postgresql.org>
Subject: Array function
Message-ID: <20041101003614.GG13884@fetter.org>
Mime-Version: 1.0
Content-Type: multipart/mixed; boundary="sm4nu43k4a2Rpi4c"
Content-Disposition: inline
User-Agent: Mutt/1.4.2i
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200411/2
X-Sequence-Number: 2637


--sm4nu43k4a2Rpi4c
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

Folks,

Here's a little addition to the array functions & operators section of
the manual.  It adds a function array() to the list.

Cheers,
D
-- 
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

--sm4nu43k4a2Rpi4c
Content-Type: text/plain; charset=us-ascii
Content-Disposition: attachment; filename="array_func.diff"

Index: doc/src/sgml/func.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/func.sgml,v
retrieving revision 1.221
diff -u -r1.221 func.sgml
--- doc/src/sgml/func.sgml	26 Oct 2004 22:16:11 -0000	1.221
+++ doc/src/sgml/func.sgml	1 Nov 2004 00:33:22 -0000
@@ -6928,6 +6928,20 @@
 	<entry><literal>string_to_array( 'xx~^~yy~^~zz', '~^~')</literal></entry>
 	<entry><literal>{xx,yy,zz}</literal></entry>
        </row>
+       <row>
+	<entry>
+     <literal>
+      <function>array</function>
+      (single-column SELECT)
+     </literal>
+    </entry>
+	<entry><type>anyarray</type></entry>
+    <entry>
+     turns a single-column <literal>SELECT</literal> statement into an array
+    </entry>
+    <entry><literal>array(SELECT foo FROM bar)</literal></entry>
+    <entry><literal>{1,2,3}</literal></entry>
+       </row>
       </tbody>
      </tgroup>
     </table>

--sm4nu43k4a2Rpi4c--