Re: select fails inside function, but works otherwise

>>>>> "Tom" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

Tom> Daniel Wickstrom <danw(at)rtp(dot)ericsson(dot)se> writes:
>> -- This select is failing. It does not return the correct
>> value -- when object_id = 44

>> select context_id, security_inherit_p into context_id,
>> security_inherit_p from acs_objects where object_id =
>> check_path__object_id;

Tom> Try distinguishing the field names from the plpgsql variable
Tom> names. I believe the machine is seeing this as a command to
Tom> select the current values of the plpgsql variables (ie, two
Tom> NULLs) into those same variables. IIRC, unqualified names
Tom> will be matched first to plpgsql variables and only second to
Tom> fields of the query tables.

That was the problem.

Thanks,

Dan