On Wed, Dec 10, 2003 at 05:08:19PM -0800, Joe Conway wrote: > David Fetter wrote: > >I've come up with yet another little hack, this time for turning 1-d > >arrays into CSV format. > > You mean like this (which is new in 7.4)? > > regression=# select array_to_string (array[1,2,3], ','); > array_to_string > ----------------- > 1,2,3 > (1 row)
Not quite. The CSV thing quotes the way you'd see in CSV files, as in SELECT csv(array['"1'::text, '2'::text, '3'::text]); csv ----------- """1",2,3 > See: > http://www.postgresql.org/docs/current/static/functions-array.html It's great, and I use it :) > >It's very handy in conjunction with the array_accum aggregate (can > >this be made a standard aggregate?) in > ><http://developer.postgresql.org/docs/postgres/xaggr.html>. > > Early in the 7.4 dev cycle array_accum() was actually in cvs as a > built-in C function (and it still does exist in PL/R as such). But > toward the end of the cycle an objection was raised and it was > removed. Search the archives in the May/June 2003 timeframe. Um, OK. It would be kinda handy, tho. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 cell: +1 415 235 3778 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])