Re: Can't use WITH in a PERFORM query in PL/pgSQL?

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Can't use WITH in a PERFORM query in PL/pgSQL?
Дата
Msg-id 4E9EF922020000250004225E@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: Can't use WITH in a PERFORM query in PL/pgSQL?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> I think it wouldn't be an unreasonable thing to just interpret a
> SELECT with no INTO clause as being a PERFORM (ie execute and
> discard results).

FWIW, that would probably confuse people coming from MS SQL Server
or Sybase ASE, since doing that in Transact-SQL would return a
result set.  Any stored procedure can produce an arbitrarily
intermixed stream of result sets, information lines, and error
messages.

-Kevin

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Can't use WITH in a PERFORM query in PL/pgSQL?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Can't use WITH in a PERFORM query in PL/pgSQL?