On þri, 2007-06-05 at 19:33 +0300, veejar wrote: > Hello! > > I have such field in my table: > > field1 > ------- > 1 > 2 > 3 > 4 > 5 > > > I want to get such result from select: > '1,2,3,4,5' - join all values in field1 with ',' > // result must be varchar. > > Help to write SELECT-query for this task.
create an aggregate function and use that in your select. http://www.postgresql.org/docs/8.2/static/sql-createaggregate.html google reminded me of the mysql compatibility project, whose implementation for group_concat() can be found here: http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/mysqlcompat/mysqlcompat/aggregate.sql?rev=1.2&content-type=text/x-cvsweb-markup gnari ---------------------------(end of broadcast)--------------------------- TIP 1: 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
