Re: parameterized views?

Thanks for responding Joe but, not exactly.  I'm looking for something a
little simpler, 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;      (where 15 would replace $1)

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

Thanks again,
Linn

"Joe Conway" <mail@joeconway.com> wrote in message
news:3D743B44.2080601@joeconway.com...
> Linn Kubler wrote:
> > Hi,
> >
> > Is it possible to have parameterized views?  Guess I'm thinking of
> > something like a posiitonal parameter in a view.  If it is possible I'd
> > sure appreciate an example.
> >
>
> In 7.3 (starting beta this week) you can return sets (rows and columns)
> from table functions. For example:
>
> test=# create table foo(f1 int, f2 text, f3 text[], primary key (f1,f2));
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> 'foo_pkey' for table 'foo'
> CREATE TABLE
> test=# insert into foo values(0,'a','{"a0","b0","c0"}');
> INSERT 664851 1
> test=# insert into foo values(1,'b','{"a1","b1","c1"}');
> INSERT 664852 1
> test=# insert into foo values(2,'c','{"a2","b2","c2"}');
> INSERT 664853 1
> test=# create or replace function get_foo(int) returns setof foo as
> 'select * from foo where f1 > $1' language sql;
> CREATE FUNCTION
> test=# select * from get_foo(0);
>   f1 | f2 |     f3
> ----+----+------------
>    1 | b  | {a1,b1,c1}
>    2 | c  | {a2,b2,c2}
> (2 rows)
>
> Is this what you're looking for?
>
> HTH,
>
> Joe
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org