Re: Expression index with function based on current_user?

Fredrik Olsson <fredrik.olsson@treyst.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