Received: from thirstydog.dsl.net (thirstydog.dsl.net [65.84.81.4]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fASFWam80063 for ; Wed, 28 Nov 2001 10:32:36 -0500 (EST) (envelope-from james@lrgmail.com) Received: from jameslt (65-85-235-195.client.dsl.net [65.85.235.195]) by thirstydog.dsl.net (Postfix) with SMTP id EABFE191A7C; Wed, 28 Nov 2001 10:32:39 -0500 (EST) Message-ID: <000c01c17822$c255ab20$1600000a@lrg.office> From: "James Orr" To: "Glenn MacGregor" , References: <012e01c17815$f6f85240$4d00a8c0@catamount> Subject: Re: View question Date: Wed, 28 Nov 2001 10:38:41 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200111/384 X-Sequence-Number: 5766 Hi Glenn, Just make the column "type" part of the view. Then use a WHERE when you select from the view. - James ----- Original Message ----- From: "Glenn MacGregor" To: Sent: Wednesday, November 28, 2001 9:07 AM Subject: [SQL] View question 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