| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | Andreas Pflug <Andreas(dot)Pflug(at)web(dot)de> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: array functions - request for opinions (was Re: [PATCHES] |
| Date: | 2003-05-26 16:13:55 |
| Message-ID: | 3ED23D43.4090507@joeconway.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Andreas Pflug wrote:
> 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.
>
Right, but Peter's desire is to *not document* the underlying function
(this was just an example, we're really discussing the new array
functions array_accum and/or array_append), and my point is that it
needs to be documented if we expect people to use it.
Joe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-05-26 16:22:47 | Re: array functions - request for opinions (was Re: [PATCHES] array |
| Previous Message | Andreas Pflug | 2003-05-26 16:01:14 | Re: array functions - request for opinions (was Re: [PATCHES] |