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
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
