On Tue, 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. >
Look into writing a simple function: http://www.postgresql.org/docs/current/static/plpgsql.html Also, consider that you should have an ORDER BY somewhere, to make sure the values get joined in the order that you expect. Regards, Jeff Davis ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
