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>
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
