Re: Multi-parameter aggregates. - Mailing list pgsql-general

From Berend Tober
Subject Re: Multi-parameter aggregates.
Date
Msg-id 438204DB.7080406@seaworthysys.com
Whole thread Raw
In response to Re: Multi-parameter aggregates.  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Michael Fuhr wrote:

>On Mon, Nov 21, 2005 at 11:03:22AM -0500, Berend Tober wrote:
>
>
>>I'm interested in defining a covariance aggregate function.
>>
>>
>
>I think aggregates must take a single value, so the above won't
>work as written.  However, in PostgreSQL 8.0 or later you could
>define the aggregate's base type to be a composite type
>

Thanks. I briefly explored something like that, using the existing POINT
data type, but didn't press it too far, pending mailling list advice.

Regards,
Berend


Attachment

pgsql-general by date:

Previous
From: Berend Tober
Date:
Subject: Re: Multi-parameter aggregates.
Next
From: Bill Moseley
Date:
Subject: Re: SQL Help: Multiple LEFT OUTER JOINs