Re: Versionning (was: Whole-row comparison)

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Versionning (was: Whole-row comparison)
Date: 2007-06-04 13:12:30
Message-ID: 20070604131230.GI32320@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, Jun 04, 2007 at 01:40:18PM +0300, christian(dot)roche(dot)ext(at)nsn(dot)com wrote:
> case ? The nicest thing would really to have parametrized view. Is
> there any fundamental reason why such a beast does not exist, or is it
> only postgres (compared to higher-level RDBMS) ?

I don't think there's a fundamental reason, no. But why couldn't you
change your query to issue the SRF directly, with the parameter:

SELECT * FROM some_srf(param1, param2)?

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
"The year's penultimate month" is not in truth a good way of saying
November.
--H.W. Fowler

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2007-06-04 14:52:48 Re: perlu: did I find a bug, or did I make one?
Previous Message Pavel Stehule 2007-06-04 12:15:08 Re: [SQL] Jumping Weekends