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.
