Re: parameterized views?

Linn Kubler wrote:
> Thanks for responding Joe but, not exactly. I'm looking for something
> more like this:
>
> create view myview as
> select f1, f2, f3 from mytable where f3 = $1;
>
> And then be able to call the view passing it a parameter somehow.
> Possibly like:
>
> select * from myview where f3 = 15;

I believe the optimizer will see this as exactly the same query as
create view myview as
select f1, f2, f3 from mytable;
select * from myview where f3 = 15;
so I don't think you'd get any different execution time.

Are you looking to avoid parsing overhead, similar to a prepared
statement (also new in 7.3)? In any case what you're looking for does
not exist currently, and I don't know of anyone working on it.

> Something like that. Returning sets from a function looks promising as
> you described below but, 7.3 seems like it's a long way off if it's just
> going to beta now.

It depends how you define "a long way off". I'd *guess* 7.3 will be
released within about 2 months of starting beta -- but no promises of
course.

Joe