Re: Multi-parameter aggregates.

Поиск
Список
Период
Сортировка
Искать
От
Florian G. Pflug
Тема
Re: Multi-parameter aggregates.
Дата
Msg-id
43822500.6090205@phlo.org
Ответ на
Список
Дерево обсуждения
Re: Multi-parameter aggregates. "Hakan Kocaman" <Hakan.Kocaman@digame.de>
Re: Multi-parameter aggregates. Berend Tober <btober@seaworthysys.com>
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 по дате отправления
От: Eric E
Дата:
Сообщение: Re: to create a database...
От: Michael Fuhr
Дата:
FAQ