Re: Returning NULL results?

Mario Splivalo wrote:
> 
> Of course, if it returns no rows, I'm presented with an error, saying:
> 
> ERROR:  record "rec" has no field "_qv"
> 
> This is logical. My question would be is there a way around this
> withouth first doing SELECT COUNT(*) FROM tmbBids WHERE ..., and then if
> COUNT(*) is zero THEN bidCount := NULL ELSE if COUNT(*) is not zero then
> do SELECT from the begining?

Could you check the FOUND variable? As in IF NOT FOUND THEN RETURN NULL

--   Richard Huxton  Archonet Ltd