Hi,
> Here the result of "SELECT * FROM test1v" depends on who issued the query.
As a more general case, I sometimes load parameters into a utility table,
and use them to dynamically restrict the view's output. Downside: it's a
multistatement operation... however, when wrapping complex queries into
functions gives the planner a bad time, this will solve the issue.
Bèrto
--
==============================
If Pac-Man had affected us as kids, we'd all be running around in a
darkened room munching pills and listening to repetitive music.