Postgres Pro
Downloads
Home   >   mailing lists

View question - Mailing list pgsql-sql

From Glenn MacGregor
Subject View question
Date
Msg-id 012e01c17815$f6f85240$4d00a8c0@catamount
Whole thread Raw
List pgsql-sql
Tree view
Hi All,
 
Thanks Josh for the help on the last question.  Is there a way to create a view so I can insert parameters?
The docs have the example:
 
create view kinds as select * from movies where type = 'Comedy';
 
select * from kinds;
 
What if I want a view where the type is a variable?  Is there a way to pass data along?
 
    Thanks
 
        Glenn

pgsql-sql by date:

Previous
From: "Johnny Jørgensen"
Date:
Subject: PL/pgSQL loops?
Next
From: Markus Bertheau
Date:
Subject: Re: Queue in SQL