Re: array functions - request for opinions (was Re: [PATCHES]

From: Andreas Pflug <Andreas(dot)Pflug(at)web(dot)de>
To: Joe Conway <mail(at)joeconway(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: array functions - request for opinions (was Re: [PATCHES]
Date: 2003-05-26 16:01:14
Message-ID: 3ED23A4A.1030107@web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2003-05-26 16:13:55 Re: array functions - request for opinions (was Re: [PATCHES]
Previous Message Joe Conway 2003-05-26 15:57:17 Re: IS OF