Re: proposal for 8.3: Simultaneous assignment for PL/pgSQL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: proposal for 8.3: Simultaneous assignment for PL/pgSQL
Дата
Msg-id 2921.1154970700@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: proposal for 8.3: Simultaneous assignment for PL/pgSQL  (Martijn van Oosterhout <kleptog@svana.org>)
Ответы Re: proposal for 8.3: Simultaneous assignment for PL/pgSQL
Список pgsql-hackers
Martijn van Oosterhout <kleptog@svana.org> writes:
> Well, you can implement it. After all, the CALL syntax is merely
> syntactic sugar. You could (if you wanted to) do the following:

> CREATE FUNCTION foo( a TEXT IN, b TEXT INOUT, c TEXT OUT ) as blah...

> And in a pl/pgsql function, translate: "CALL foo(a,b,c)" 
> into "(b,c) = foo(a,b)" internally.

No, Pavel's right: that doesn't work because it's ambiguous.  How do you
tell whether "CALL foo(a,b,c)" means
a,b,c := foo();b,c := foo(a);c := foo(a,b);select foo(a,b,c);

There could be functions foo matching all four interpretations.
        regards, tom lane


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

Предыдущее
От: Mark Wong
Дата:
Сообщение: Re: AOL Research open-research
Следующее
От: Joshua Reich
Дата:
Сообщение: Re: AOL Research open-research