parameters in views - Mailing list pgsql-general

From John Smith
Subject parameters in views
Date
Msg-id 20030214223044.91080.qmail@web40702.mail.yahoo.com
Whole thread Raw
List pgsql-general

Is it possible to have "parameters" in views? Such as:

create view v_t1t2 as
select t1.*, t2.*
from t1
left join t2 on t1.id=t2.t1id and t2.other_id = $param
order by t2.name;

John



Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day

pgsql-general by date:

Previous
From: Patrick Nelson
Date:
Subject: Re: pgtcl way of specifying a user [SOLVED]
Next
From: Jeffrey Baker
Date:
Subject: Re: In 7.3.1, will I be able to reindex toast?