Re: [DOCS] Array function
David Fetter wrote: > Please find attached a different diff :) If you want to write a note, use the element. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [DOCS] Array function
BTW, it seems it would be useful to dedicate a chapter to array handling, since it's something that's not very common amongst databases. On Sun, Oct 31, 2004 at 04:36:14PM -0800, David Fetter wrote: > 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 -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [DOCS] Array function
On Mon, Nov 01, 2004 at 08:47:05PM +0100, Peter Eisentraut wrote: > David Fetter wrote: > > Please find attached a different diff :) > > If you want to write a note, use the element. Thanks for the tip :) Fixed, attaching a diff against CVS HEAD. 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 20:21:02 - @@ -6931,6 +6931,18 @@ + + +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 7: don't forget to increase your free space map settings
Re: [DOCS] Array function
On Mon, Nov 01, 2004 at 01:59:13PM -0600, Jim C. Nasby wrote: > On Sun, Oct 31, 2004 at 04:36:14PM -0800, David Fetter wrote: > > 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 > > BTW, it seems it would be useful to dedicate a chapter to array > handling, since it's something that's not very common amongst > databases. I guess it depends what you mean. Oracle has "subtables," and other things have stuff like that. Also, it's in the SQL standard... Anyhow, where do you think it should go? Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(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
David Fetter wrote: > Anyhow, where do you think it should go? In the chapter on data types -- where it already is. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
