Re: execute/perform and FOUND

Поиск
Список
Период
Сортировка
От Marcin Mank
Тема Re: execute/perform and FOUND
Дата
Msg-id 04bb01c6dd7c$786cfe90$0c67a8c0@maniek
обсуждение исходный текст
Ответ на execute/perform and FOUND  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Ответы Re: execute/perform and FOUND  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Список pgsql-general
> gives the result below. It seems inconsistent to me with
> regard to the FOUND variable. I would expect FOUND to always
> be false regardless of whether I use EXECUTE or PERFORM. I
> certainly do not expect it to be true for the third EXECUTE
> even assuming that PERFORM may have a bug. What is it that I
> am missing out on here ?
>

With:

 perform cmd;
 raise notice ''found (perform): %'', found;

You effectively do:
select 'select 1 from test where fk_item=1324314' ;


Try:

perform 1 from test where fk_item=1324314

Greetings
Marcin

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

Предыдущее
От: Karsten Hilbert
Дата:
Сообщение: Re: execute/perform and FOUND
Следующее
От: Karsten Hilbert
Дата:
Сообщение: Re: execute/perform and FOUND