Re: plpgsql FOUND Variable - Mailing list pgsql-general

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
>
>
>
>