Re: [Dbdpg-general] Re: CSV hack

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 david@fetter.org http://fetter.org/
phone: +1 510 893 6100    cell: +1 415 235 3778