Bill Moran <wmoran@potentialtech.com> writes:
> Rajat Katyal wrote:
>> But FOUND variable is always returning true even my query is
>> returning *0 records.*
> FOUND appears to work correctly in the hundreds of stored procedures I wrote
> last month. (At least, I haven't found any problems _yet_)
Works for me too, in recent releases. I believe PERFORM did not originally
set FOUND ... are you reading the documentation that goes with your server
version?
[ digs in CVS logs... ] Here we go:
2002-06-24 19:12 tgl
* src/pl/plpgsql/src/pl_exec.c: plpgsql's PERFORM statement now
sets FOUND depending on whether any rows were returned by the
performed query. Per recent pgsql-general discussion.
So it should work in 7.3 or later.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
