diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index aee74366b01..67500340b0f 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.459 2008/11/13 23:01:09 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.460 2008/11/14 00:51:46 tgl Exp $ --> <chapter id="functions"> <title>Functions and Operators</title> @@ -9482,6 +9482,17 @@ SELECT NULLIF(value, '(none)') ... <entry><literal>string_to_array('xx~^~yy~^~zz', '~^~')</literal></entry> <entry><literal>{xx,yy,zz}</literal></entry> </row> + <row> + <entry> + <literal> + <function>unnest</function>(<type>anyarray</type>) + </literal> + </entry> + <entry><type>setof anyelement</type></entry> + <entry>expand an array to a set of rows</entry> + <entry><literal>unnest(ARRAY[1,2])</literal></entry> + <entry><literal>1</literal><para><literal>2</literal></para> (2 rows)</entry> + </row> </tbody> </tgroup> </table> |