Skip site navigation (1) Skip section navigation (2)

Re: Concat field result in select query

From: Julien Cigar <jcigar(at)ulb(dot)ac(dot)be>
To: Nacef LABIDI <nacef(dot)l(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Concat field result in select query
Date: 2008-08-22 16:07:15
Message-ID: 1219421235.2696.5.camel@frodon.be-bif.ulb.ac.be (view raw or flat)
Thread:
Lists: pgsql-sql
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: jcigar(at)ulb(dot)ac(dot)be
@biobel: http://biobel.biodiversity.be/person/show/471
Tel : 02 650 57 52


In response to

Responses

pgsql-sql by date

Next:From: Lennin CaroDate: 2008-08-22 16:16:25
Subject: Re: Concat field result in select query
Previous:From: Nacef LABIDIDate: 2008-08-22 14:15:01
Subject: Re: Concat field result in select query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group