public inbox for [email protected]  

help / color / mirror / Atom feed

From: David Fetter <[email protected]>
To: PostgreSQL Docs <[email protected]>
Subject: Array function
Date: Sun, 31 Oct 2004 16:36:14 -0800
Message-ID: <[email protected]> (raw)

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 [email protected] http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

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>


Attachments:

  [text/plain] array_func.diff (936B, 2-array_func.diff)
  download | inline 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>

view thread (13+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Array function
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox