Re: PLpgSQL-Problem

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PLpgSQL-Problem
Дата
Msg-id 10971.1082220377@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PLpgSQL-Problem  ("Thomas Chille" <thomas@chille.de>)
Список pgsql-general
"Thomas Chille" <thomas@chille.de> writes:
> in every documentation(7.5 too) i can read that i can pass a row to a
> plpgsql function. but how u know it does not work.

It does work ... from a SQL statement.  The problem you are running into
is that a whole-row variable of a plpgsql function can't be passed as a
unit into a SQL statement.  (I thought this limitation was documented
somewhere in the plpgsql chapter, but right at the moment I can't find
anything about it.)

> And if the documentation is wrong, is this normal for the postgres-docs?

The documentation is not perfect.

            regards, tom lane

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

Предыдущее
От: "Thomas Chille"
Дата:
Сообщение: Re: PLpgSQL-Problem
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: [HACKERS] Remove MySQL Tools from Source?