Re: Expression index with function based on current_user?

Ü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:
> CREATE VIEW foo AS
>   SELECT * FROM private.t_foo WHERE private.haveaccess();
> GRANT ALL ON foo TO public;
> 
> Using rules I then make the view updatable (In reality views fetch and 
> write data to multiple tables usually). This works fine, but I have some 
> thought on performance in the future.
> 
> 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?

No, but you probably can crete index on static function
user_has_access(username) and then use that func in
private.haveaccess()

------------
Hannu