Re: plpgsql FOUND Variable

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(at)meerkatsoft(dot)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
>
>
>
>