Re: aggregate function

From: "Claudio Lapidus" <clapidus(at)hotmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>, "Greg Stark" <gsstark(at)mit(dot)edu>
Subject: Re: aggregate function
Date: 2003-09-06 12:18:10
Message-ID: BAY7-DAV10SOwcqQVPm000436fd@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Greg Stark wrote:
> Is this example helpful?

Yes, perfect! Thank you.
cl.

>
> create function concat_agg_accum(varchar, varchar) returns varchar
> as 'select $1 || '', '' || $2'
> language sql
> strict immutable;
>
> create aggregate concat_agg (
> basetype = varchar,
> stype = varchar,
> sfunc = concat_agg_accum
> );
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marek Lewczuk 2003-09-06 13:55:12 Needed function IF(expr, expr, expr)
Previous Message Nigel J. Andrews 2003-09-06 09:58:35 Re: tsearch2 and unexpected exists (Function defn)