Re: Multi-parameter aggregates.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Berend Tober <btober(at)seaworthysys(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Multi-parameter aggregates.
Date: 2005-11-21 17:06:40
Message-ID: 2584.1132592800@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Berend Tober <btober(at)seaworthysys(dot)com> writes:
> I'm stuck on not knowing how to define a
> aggregate that takes more that one variable as its argument,

That's because there isn't any way to do that. It's on the TODO list
I believe. In the meantime, you could possibly kluge it up by
defining a composite type to be the aggregate's argument, and calling
it like
SELECT covariance(row(...)) FROM ...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2005-11-21 17:24:35 Re: TSearch2 Questions
Previous Message Michael Fuhr 2005-11-21 17:06:27 Re: Multi-parameter aggregates.