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

From Florian G. Pflug
Subject Re: Multi-parameter aggregates.
Date
Msg-id 43822500.6090205@phlo.org
Whole thread Raw
In response to Re: Multi-parameter aggregates.  (Joe Conway <mail@joeconway.com>)
List pgsql-general
Joe Conway wrote:
> Berend Tober wrote:
>
>> I'm stuck on not knowing how to define a aggregate that takes more
>> that one variable as its argument
But I guess it _could_ take an array as argument, maybe even
a record (postgresql pseudonym for what's called a structure in C).

You'd use it with the following syntax (array):
select covariance(array[x, y]) from t ;

or, for a "record"-parameter (I didn't test it - I just
guess that it should work...)
select covariance((x, y)) from t ;

greetings, Florian Pflug

pgsql-general by date:

Previous
From: Eric E
Date:
Subject: Re: to create a database...
Next
From: Michael Fuhr
Date:
Subject: Re: Multi-parameter aggregates.