Re: Multi-parameter aggregates.

Поиск
Список
Период
Сортировка
От Florian G. Pflug
Тема Re: Multi-parameter aggregates.
Дата
Msg-id 43822500.6090205@phlo.org
обсуждение исходный текст
Ответ на Re: Multi-parameter aggregates.  (Joe Conway <mail@joeconway.com>)
Список 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 по дате отправления:

Предыдущее
От: Eric E
Дата:
Сообщение: Re: to create a database...
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Multi-parameter aggregates.