From gtm@oracom.com Wed Nov 28 14:02:56 2001 Received: from degroens.oracom.com ([63.238.138.68]) by postgresql.org (8.11.3/8.11.4) with SMTP id fASE2um76381 for ; Wed, 28 Nov 2001 09:02:56 -0500 (EST) (envelope-from gtm@oracom.com) Received: (qmail 27198 invoked from network); 28 Nov 2001 10:20:18 -0000 Received: from unknown (HELO catamount) (192.168.253.253) by 192.168.253.2 with SMTP; 28 Nov 2001 10:20:18 -0000 Message-ID: <012e01c17815$f6f85240$4d00a8c0@catamount> From: "Glenn MacGregor" To: Subject: View question Date: Wed, 28 Nov 2001 09:07:07 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_012B_01C177EC.0E1C2FC0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200111/381 X-Sequence-Number: 5763 This is a multi-part message in MIME format. ------=_NextPart_000_012B_01C177EC.0E1C2FC0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 =3D '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 ------=_NextPart_000_012B_01C177EC.0E1C2FC0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi All,
 
Thanks Josh for the help on the last=20 question.  Is there a way to create a view so I can insert=20 parameters?
The docs have the example:
 
create view kinds as select * from movies = where=20 type =3D 'Comedy';
 
select * from kinds;
 
What if I want a view where the type is a= =20 variable?  Is there a way to pass data along?
 
    Thanks
 
       =20 Glenn
------=_NextPart_000_012B_01C177EC.0E1C2FC0-- From james@lrgmail.com Wed Nov 28 15:32:36 2001 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