| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | David Fetter <david(at)fetter(dot)org> |
| Cc: | PG Hackers <pgsql-hackers(at)postgresql(dot)org>, "DBD:"(at)svr1(dot)postgresql(dot)org:Pg <dbdpg-general(at)svr3(dot)postgresql(dot)org> |
| Subject: | Re: CSV hack |
| Date: | 2003-12-11 01:08:19 |
| Message-ID: | 3FD7C383.4030201@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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)
See:
http://www.postgresql.org/docs/current/static/functions-array.html
> 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.
Joe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2003-12-11 01:54:59 | Re: [Dbdpg-general] Re: CSV hack |
| Previous Message | David Fetter | 2003-12-10 23:05:34 | CSV hack |