Re: Proposal: OUT parameters for plpgsql

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Proposal: OUT parameters for plpgsql
Дата
Msg-id 87d5tscnwc.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: Proposal: OUT parameters for plpgsql  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> > I would have expected the return value to be an extra column added to the
> > record.
> 
> I'd prefer not to do that, because having a "return type" that's
> different from the true return type of the function (ie the RECORD)
> is going to cause untold amounts of confusion.

Yes, I can see that angle. I was just thinking that since the whole point of
this exercise was to achieve some compatibility with a specific interface that
your hands were going to be tied.

But that other point about other systems only allowing IN or INOUT on
procedures where normal return values aren't allowed at all seems to resolve
that issue.

-- 
greg



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

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Using new copy libpq functions on a v2 protocol backend
Следующее
От: Neil Conway
Дата:
Сообщение: locks in CREATE TRIGGER, ADD FK