Postgres Pro
Downloads
Home   >   mailing lists

Re: array functions - request for opinions (was Re: [PATCHES] - Mailing list pgsql-hackers

From Andreas Pflug
Subject Re: array functions - request for opinions (was Re: [PATCHES]
Date
Msg-id 3ED23A4A.1030107@web.de
Whole thread Raw
In response to Re: array functions - request for opinions (was Re: [PATCHES]  (Joe Conway <mail@joeconway.com>)
Responses Re: array functions - request for opinions (was Re: [PATCHES]
List pgsql-hackers
Tree view 
Joe Conway wrote:

> How can you create an aggregate using an operator as a transition 
> function?
>
> =# CREATE AGGREGATE myagg
> -# (
> (#   BASETYPE = text,
> (#   SFUNC = '||',
> (#   STYPE = text,
> (#   INITCOND = ''
> (# );
> ERROR:  AggregateCreate: function ||(text, text) does not exist 

Use the function underlying the operator, in this case textcat.

Regards,
Andreas

pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: IS OF
Next
From: Joe Conway
Date:
Subject: Re: array functions - request for opinions (was Re: [PATCHES]