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:28:49
Message-ID: 1219422529.2696.11.camel@frodon.be-bif.ulb.ac.be (view raw or flat)
Thread:
Lists: pgsql-sql
Also, the array_accum aggregate isn't present by default, you need to
create it with :

CREATE AGGREGATE array_accum (anyelement)
(
    sfunc = array_append,
    stype = anyarray,
    initcond = '{}'
);

On Fri, 2008-08-22 at 18:24 +0200, Julien Cigar wrote:
> 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


In response to

pgsql-sql by date

Next:From: Allan KamauDate: 2008-08-22 18:41:10
Subject: Re: Re: Efficiently determining the number of bits set in the contents of, a VARBIT field
Previous:From: Julien CigarDate: 2008-08-22 16:24:33
Subject: Re: Concat field result in select query

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