> 2. Issue a query like: > > SELECT * > FROM view_of_salaries_based_on_current_user > WHERE my_side_effect_function_that_inserts_into_a_temp_table(salary, > employee);
An SRF will guarantee an execution order and work for security purposes, but getting your function with side effects to run early would be rather challenging. Somehow you would need to make the planner think the function is fairly selective without it actually being that way and the only way that I'm aware of to get the planner to consider a functions selectivity is to index it. But how do you index the function without knowing all of the values? -- ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
