Re: Expression index with function based on current_user?

Fredrik Olsson <fredrik(dot)olsson(at)treyst(dot)se> 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 parameterless, you had better be more specific about what
it depends on.

regards, tom lane