Re: concatenate text

From: Allan Wang <allanvv(at)gmail(dot)com>
To: Sterpu Victor <victor(at)ambra(dot)ro>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: concatenate text
Date: 2005-09-05 00:39:22
Message-ID: 1125880762.10725.3.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 2005-09-04 at 20:37 -0400, Allan Wang wrote:
> On Mon, 2005-09-05 at 03:00 +0300, Sterpu Victor wrote:
> > Can I do something like this?
> > SELECT sum(name) FROM table;
> >
>
> You can add a custom aggregate function that turns your data into an
> array, see http://www.postgresql.org/docs/current/static/xaggr.html
>
> You can then use array_to_string if you want them comma seperated or
> something.
>
> Allan Wang

Whoops, I keep forgetting to hit reply to all.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-09-05 02:00:21 Re: concatenate text
Previous Message Chris Travers 2005-09-05 00:08:07 Re: Query questions