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 <alex@meerkatsoft.com> 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
>
>
>
>
