execute/perform and FOUND - Mailing list pgsql-general

From Karsten Hilbert
Subject execute/perform and FOUND
Date
Msg-id 20060921110632.GA10331@merkur.hilbert.loc
Whole thread Raw
Responses Re: execute/perform and FOUND  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Re: execute/perform and FOUND  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Hi,

I am utterly confused now. Running the attached script on Debian:

postgresql:
  Installiert:7.5.21
  Mögliche Pakete:7.5.21
  Versions-Tabelle:
 *** 7.5.21 0
        990 ftp://ftp.gwdg.de testing/main Packages
        100 /var/lib/dpkg/status
     7.4.7-6sarge3 0
        500 ftp://ftp.gwdg.de stable/main Packages
        500 ftp://ftp.de.debian.org stable/main Packages
     7.4.7-6sarge2 0
        500 http://security.debian.org stable/updates/main Packages

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 ?

BEGIN
CREATE TABLE
CREATE FUNCTION
select * from test;
 fk_item
---------
(0 Zeilen)

select test();
psql:00-test.sql:33: NOTICE:  running: select 1 from test where fk_item=1324314
psql:00-test.sql:33: NOTICE:  found (execute 1): f
psql:00-test.sql:33: NOTICE:  found (execute 2): f
psql:00-test.sql:33: NOTICE:  found (perform): t
psql:00-test.sql:33: NOTICE:  found (execute 3): t
 test
------
 t
(1 Zeile)

rollback;
ROLLBACK

Thanks,
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

Attachment

pgsql-general by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: [OT]plz xxxxxxxxxxx me
Next
From: Karsten Hilbert
Date:
Subject: Re: execute/perform and FOUND