In article [EMAIL PROTECTED] you wrote:
You also need to quote values containing the separator.
Roight! Thanks for the heads-up :) And now, version 2.
Cheers,
D
CREATE OR REPLACE FUNCTION csv(anyarray) RETURNS TEXT AS
'DECLARE
in_array ALIAS FOR $1;
temp_string TEXT;
Kind people,
I've come up with yet another little hack, this time for turning 1-d
arrays into CSV format. 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.
Here 'tis...
CREATE OR
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:
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], ',');
You also need to quote values containing the separator.
cheers
andrew (who used to set creating CSV as a programming exercise -
students almost never get it right)
David Fetter wrote:
Kind people,
I've come up with yet another little hack, this time for turning 1-d
arrays into CSV format.