execute/perform and FOUND
От | Karsten Hilbert |
---|---|
Тема | execute/perform and FOUND |
Дата | |
Msg-id | 20060921110632.GA10331@merkur.hilbert.loc обсуждение исходный текст |
Ответы |
Re: execute/perform and FOUND
Re: execute/perform and FOUND |
Список | 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
Вложения
В списке pgsql-general по дате отправления: