Re: Concat field result in select query

[Julien Cigar <jcigar(at)ulb(dot)ac(dot)be>]

of course: http://rafb.net/p/EOaYfO59.html

Julien

On Fri, 2008-08-22 at 15:58 +0200, Nacef LABIDI wrote:
> any explanations ?
> 
> On Fri, Aug 22, 2008 at 6:07 PM, Julien Cigar <jcigar(at)ulb(dot)ac(dot)be>
> wrote:
>         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
>         
> 
> 
-- 
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