Re: PL/pgSQL PERFORM with CTE

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема Re: PL/pgSQL PERFORM with CTE
Дата
Msg-id 884E56B9-1937-4594-958D-A26306FC0B15@justatheory.com
обсуждение исходный текст
Ответ на Re: PL/pgSQL PERFORM with CTE  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: PL/pgSQL PERFORM with CTE
Список pgsql-hackers
On Aug 20, 2013, at 3:38 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:

> pg_notify returns void, so there are no necessary casting to void
>
> so enhanced check - so all returned columns are void should be enough

What if I call another function I wrote myself that returns an INT, but I do not care about the INT? Maybe that
functiondoes the insert and returns the number of inserted rows. 

I can think of all kinds of reasons this might be the case; whether they are good or bad approaches is immaterial:
sometimesyou work with what you have. 

I am find with PERFORM to determine when a query's results should be discarded. I just think it needs to cover a few
morecases. 

Best,

David


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Fix Windows socket error checking for MinGW
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: PL/pgSQL PERFORM with CTE