Search Postgresql Archives

Re: execute/perform and FOUND

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux