Re: [Help] AGGREGATE problem w/v7.0

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [Help] AGGREGATE problem w/v7.0
Дата
Msg-id 26090.992440925@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [Help] AGGREGATE problem w/v7.0  ("Itzinger, Oskar" <oitzinger@opec.org>)
Список pgsql-general
"Itzinger, Oskar" <oitzinger@opec.org> writes:
> /why/ does SELECT give up with
> ERROR:  SQL-language function not supported in this context.

The message seems perfectly clear to me ;-)

> - How can I rectify this situation

Update to 7.1:

regression=# SELECT id, foo_a(entry) FROM tmp GROUP BY id;
 id  |   foo_a
-----+------------
 abc | , kls, mnr
 def | , opq, zyw
(2 rows)

Not that I'd recommend a SQL function for an aggregate, mind you.
plpgsql would probably be faster/better.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: very big problem with NULL
Следующее
От: "Gregory Wood"
Дата:
Сообщение: Re: PLPGSQL: Using Transactions and locks