[DOCS] Translators wanted for 8.0 Release
Folks, I'm looking to collect the translators for the 8.0 release of PostgreSQL. Anyone interested in helping out, please e-mail me. If you just recieved an e-mail on the translators list, then you needn't respond to this message. If you thought you were on the translators list, but did not get a message a few minutes ago, then I'm probably bouncing your messages; please contact me. --Josh Berkus PGSQL Core Team ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[DOCS] Array function
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 - 1.221
+++ doc/src/sgml/func.sgml 1 Nov 2004 00:33:22 -
@@ -6928,6 +6928,20 @@
string_to_array( 'xx~^~yy~^~zz', '~^~')
{xx,yy,zz}
+
+
+
+ array
+ (single-column SELECT)
+
+
+ anyarray
+
+ turns a single-column SELECT statement into an array
+
+array(SELECT foo FROM bar)
+{1,2,3}
+
---(end of broadcast)---
TIP 8: explain analyze is your friend
Re: [DOCS] Translators wanted for 8.0 Release
On Sun, Oct 31, 2004 at 05:16:45PM -0700, Josh Berkus wrote: Josh, > If you thought you were on the translators list, but did not get a message a > few minutes ago, then I'm probably bouncing your messages; please contact me. I'm on this group. Thanks, -- Alvaro Herrera (<[EMAIL PROTECTED]>) "Saca el libro que tu religión considere como el indicado para encontrar la oración que traiga paz a tu alma. Luego rebootea el computador y ve si funciona" (Carlos Duclós) ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [DOCS] Array function
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. regards, tom lane ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [DOCS] Array function
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 - 1.221 +++ doc/src/sgml/func.sgml 1 Nov 2004 05:19:02 - @@ -6931,6 +6931,16 @@ + + NOTE: Although it is not strictly a function +and does not appear in \df in psql, ARRAY(), +mentioned in acts much +like a table function (equivalently, a +set-returning function or a +SRF--see ) +which takes anyarray and returns a set of +anyelement. + ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
