Re: execute/perform and FOUND - Mailing list pgsql-general

From Marcin Mank
Subject Re: execute/perform and FOUND
Date
Msg-id 04bb01c6dd7c$786cfe90$0c67a8c0@maniek
Whole thread Raw
In response to execute/perform and FOUND  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: execute/perform and FOUND  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List 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 by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: execute/perform and FOUND
Next
From: Karsten Hilbert
Date:
Subject: Re: execute/perform and FOUND