> Hi all, > > I was wondering if there is a way to concatenate the > results of a field in a > select to return it as a single string. > > Example : > > my_field > -------------- > 1 > 2 > 3 > > select concat_something(my_field) from my_table group by > something; > the result expected would be someting like that : 1/2/3 > (with a separator it > would be really nice) > > I hope that I am not asking for too much ;) > > Thanks to all
you can use aggregate function, check for previous threads for this solution http://www.postgresql.org/docs/8.3/static/sql-createaggregate.html -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
