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--