Re: Any form of connection-level "session variable" ?

Tom Lane wrote:
> John McCawley  writes:
>   
>> I think I got it:
>> CREATE FUNCTION new_get_emp_id() RETURNS INTEGER AS $$ select emp_id 
>> from secureview.tbl_employee where username = (SELECT current_user) $$ 
>> LANGUAGE SQL IMMUTABLE;
>> I made the function immutable so it only calls it once, therefore no 
>> longer requiring a call per-row.
>>     
>
> Since it's obviously *not* immutable, this will come back to bite you
> sooner or later (probably sooner).  Labeling it STABLE would be
> reasonable, although I'm not certain how much that helps you.  Do you
> have indexes on the columns it's being compared to?
>   
Besides, a temp table is pretty much a session variable.

-- 
erik jones 
software development
emma(r)