View question

From: "Glenn MacGregor" <gtm(at)oracom(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: View question
Date: 2001-11-28 14:07:07
Message-ID: 012e01c17815$f6f85240$4d00a8c0@catamount
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Bertheau 2001-11-28 14:19:13 Re: Queue in SQL
Previous Message Johnny Jørgensen 2001-11-28 12:25:52 PL/pgSQL loops?