Tom, I am using 7.3.4
The problem
_tmpRec = RECORD; _name = VARCHAR;
SELECT INTO _tmpRec * FROM address WHERE name = _name AND status = ''1'' AND last_name NOTNULL
IF FOUND THEN
RETURN ''found'';
ELSE ....
Above Query does not produce any results. Executed in psql result = 0 rows. However I do get the return string "found" back.
Alex
Tom Lane wrote:
Alex <[EMAIL PROTECTED]> writes:
when I run a SELECT INTO and the result is 0 or zero row, then I still get a positive result if
using IF FOUND THEN....
I recall Neil Conway fixed some problems with FOUND a version or two back. If you are not on 7.3.*, update. If you are, let's see the details.
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
