Re: [HACKERS] SQL procedures

Поиск
Список
Период
Сортировка
От Corey Huinker
Тема Re: [HACKERS] SQL procedures
Дата
Msg-id CADkLM=dQY=p13Mk-3gNpRLGBm3mQaLHqEFjzMJh_rTjchoo-Pw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] SQL procedures  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: [HACKERS] SQL procedures  (Andrew Dunstan <andrew.dunstan@2ndquadrant.com>)
Список pgsql-hackers

T-SQL procedures returns data or OUT variables.

I remember, it was very frustrating

Maybe first result can be reserved for OUT variables, others for multi result set


It's been many years, but if I recall correctly, T-SQL returns a series of result sets, with no description of the result sets to be returned, each of which must be consumed fully before the client can move onto the next result set. Then and only then can the output parameters be read. Which was very frustrating because the OUT parameters seemed like a good place to put values for things like "result set 1 has 205 rows" and "X was false so we omitted one result set entirely" so you couldn't, y'know easily omit entire result sets. 

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

Предыдущее
От: Ashwin Agrawal
Дата:
Сообщение: Re: [HACKERS] Commits don't block for synchronous replication
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: [HACKERS] SQL procedures