The function private.haveaccess()'s result depends on the currently logged
in user, is it still possible to create an expression index over that
function?
// Fredrik Olsson
Hello,
All functions and operators used in an index definition must be immutable,
that is, their results must
Ühel kenal päeval, K, 2006-02-08 kell 12:26, kirjutas Fredrik Olsson:
I have private tables such as this (Very simplified):
CREATE TABLE private.t_foo (
...
);
REVOKE ALL ON private.t_foo FROM public;
Different users have access to different data in the table, so I do
this view:
Fredrik Olsson [EMAIL PROTECTED] writes:
CREATE VIEW foo AS
SELECT * FROM private.t_foo WHERE private.haveaccess();
GRANT ALL ON foo TO public;
If the function is parameterless as you show, what is it accomplishing
that could not be done with grant/revoke on the view?
If it is not