Postgres Pro
Downloads
Home   >   mailing lists

Re: aggregate function - Mailing list pgsql-general

From Claudio Lapidus
Subject Re: aggregate function
Date
Msg-id BAY7-DAV10SOwcqQVPm000436fd@hotmail.com
Whole thread Raw
In response to aggregate function  ("Claudio Lapidus" <clapidus@hotmail.com>)
List pgsql-general
Tree view 
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
> );
>

pgsql-general by date:

Previous
From: "Nigel J. Andrews"
Date:
Subject: Re: tsearch2 and unexpected exists (Function defn)
Next
From: "Marek Lewczuk"
Date:
Subject: Needed function IF(expr, expr, expr)