Scott Ribe wrote:
What about:create function set_emp_id() returns void as $$ begin drop table if exists emp_1_id; select emp_id into temp emp_1_id from secureview.tbl_employee where username = current_user;end; $$ language plpgsql;create function get_emp_id() returns int as $$ return select emp_id from emp_1_id; $$ language plpgsql stable; Call set_emp_id once on connection, then use get_emp_id thereafter. Would that be any faster? (This is what Erik meant by " a temp table is pretty much a session variable" in his earlier message.)
Or, in similar fashion, use this: http://www.joeconway.com/sessfunc.tar.gz http://www.onlamp.com/pub/a/onlamp/2004/06/28/postgresql_extensions.html HTH, Joe ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
