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