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

Re: Concat field result in select query

From: "Nacef LABIDI" <nacef(dot)l(at)gmail(dot)com>
To: "Julien Cigar" <jcigar(at)ulb(dot)ac(dot)be>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Concat field result in select query
Date: 2008-08-22 13:58:22
Message-ID: f16f7ea00808220658x5a04cb10l27169ae66cfef7d6@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
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
>
>

In response to

Responses

pgsql-sql by date

Next:From: Guillaume LelargeDate: 2008-08-22 14:10:05
Subject: Re: Concat field result in select query
Previous:From: Nacef LABIDIDate: 2008-08-22 13:40:51
Subject: Concat field result in select query

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