public inbox for [email protected]
help / color / mirror / Atom feedFrom: David Fetter <[email protected]>
To: Tom Lane <[email protected]>
Cc: PostgreSQL Docs <[email protected]>
Subject: Re: Array function
Date: Sun, 31 Oct 2004 21:21:17 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
On Sun, Oct 31, 2004 at 10:40:47PM -0500, Tom Lane wrote:
> David Fetter <[email protected]> writes:
> > Here's a little addition to the array functions & operators section of
> > the manual. It adds a function array() to the list.
>
> The ARRAY() construct isn't really a function; it is a special
> syntax documented in Array Constructors,
> http://developer.postgresql.org/docs/postgres/sql-expressions.html#SQL-SYNTAX-ARRAY-CONSTRUCTORS
>
> The addition you propose is misleading, because it would lead people
> to expect to find array() in the output of \df, for example. It
> might be reasonable to put in some kind of "see also"
> cross-reference in the array functions section, but we shouldn't
> list array() as though it were just like every other function in the
> section.
Good point.
Please find attached a different diff :)
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 05:19:02 -0000
@@ -6931,6 +6931,16 @@
</tbody>
</tgroup>
</table>
+ <para>
+ <emphasis role="bold">NOTE:</emphasis> Although it is not strictly a function
+ and does not appear in \df in psql, <command>ARRAY()</command>,
+ mentioned in <xref linkend="sql-syntax-array-constructors"> acts much
+ like a <literal>table function</literal> (equivalently, a
+ <literal>set-returning function</literal> or a
+ <acronym>SRF</acronym>--see <xref linkend="queries-tablefunctions">)
+ which takes <type>anyarray</type> and returns a set of
+ <type>anyelement</type>.
+ </para>
</sect1>
<sect1 id="functions-aggregate">
Attachments:
[text/plain] array.diff (982B, 2-array.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 05:19:02 -0000
@@ -6931,6 +6931,16 @@
</tbody>
</tgroup>
</table>
+ <para>
+ <emphasis role="bold">NOTE:</emphasis> Although it is not strictly a function
+ and does not appear in \df in psql, <command>ARRAY()</command>,
+ mentioned in <xref linkend="sql-syntax-array-constructors"> acts much
+ like a <literal>table function</literal> (equivalently, a
+ <literal>set-returning function</literal> or a
+ <acronym>SRF</acronym>--see <xref linkend="queries-tablefunctions">)
+ which takes <type>anyarray</type> and returns a set of
+ <type>anyelement</type>.
+ </para>
</sect1>
<sect1 id="functions-aggregate">
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], [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