Search Postgresql Archives

Re: execute/perform and FOUND

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

 



On Thu, Sep 21, 2006 at 01:06:32PM +0200, Karsten Hilbert wrote:

> 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

PostgreSQL 7.4.13 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.2 20060729 (prerelease) (Debian 4.1.1-10)

The 7.4 docs don't say anything about execute setting FOUND
but regardless of that the PERFORM result still seems
faulty:

"A PERFORM statement sets FOUND true if it produces (and discards) a row, false if no row is produced."

I don't expect a row to be produced by the example.

Assuming EXECUTE does not touch FOUND at all the EXECUTE
part behaves consistently (namely default FOUND=FALSE at the
beginning and later whatever it was after the PERFORM).

So, what about the PERFORM ?  Why does it set FOUND to true?

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


[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