Thread: Re: plpgsql FOUND Variable

Re: plpgsql FOUND Variable

From
"Zygmuntowicz Michal"
Date:
Alex,

I had similar problem with pgsql 7.3.3 and 7.3.4 when
using SELECT INTO RECORD variable. I noticed that
FOUND is always set to TRUE, but if no result is found,
RECORD variable is filled with NULL values.

My workaround was to check for NULL field value,
if there should not be ever NULL (primary key, etc).

---
Zygmuntowicz Michal