> 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
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 <[EMAIL PROTECTED]>
> wrote:
> array_accum ?
>
>
> On Fri, 2008-08-22 at 15:40 +0200,
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.
Thank you, this is all what I need
On Fri, Aug 22, 2008 at 4:10 PM, Guillaume Lelarge
<[EMAIL PROTECTED]>wrote:
> Nacef LABIDI a écrit :
> > 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 :
>
Nacef LABIDI a écrit :
> 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 resul
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
any explanations ?
On Fri, Aug 22, 2008 at 6:07 PM, Julien Cigar <[EMAIL PROTECTED]> 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 sing
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
