array_accum ? On Fri, 2008-08-22 at 15:40 +0200, Nacef LABIDI wrote: > 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 > -- Julien Cigar Belgian Biodiversity Platform http://www.biodiversity.be Université Libre de Bruxelles (ULB) Campus de la Plaine CP 257 Bâtiment NO, Bureau 4 N4 115C (Niveau 4) Boulevard du Triomphe, entrée ULB 2 B-1050 Bruxelles Mail: [EMAIL PROTECTED] @biobel: http://biobel.biodiversity.be/person/show/471 Tel : 02 650 57 52
-- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql