pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: Versionning (was: Whole-row comparison)
Date: Mon, 4 Jun 2007 09:12:30 -0400
Message-ID: <20070604131230.GI32320@phlogiston.dyndns.org> (raw)
In-Reply-To: <CCC9DCA122011F4CA593F6A548BFFBD363016C@esebe111.NOE.Nokia.com>
References: <CCC9DCA122011F4CA593F6A548BFFBD354D259@esebe111.NOE.Nokia.com>
	<473557.7523.qm@web31803.mail.mud.yahoo.com>
	<CCC9DCA122011F4CA593F6A548BFFBD354D260@esebe111.NOE.Nokia.com>
	<CCC9DCA122011F4CA593F6A548BFFBD362FCF9@esebe111.NOE.Nokia.com>
	<20070601174711.GH24299@phlogiston.dyndns.org>
	<CCC9DCA122011F4CA593F6A548BFFBD362FCFE@esebe111.NOE.Nokia.com>
	<20070601185125.GJ24299@phlogiston.dyndns.org>
	<CCC9DCA122011F4CA593F6A548BFFBD363016C@esebe111.NOE.Nokia.com>

On Mon, Jun 04, 2007 at 01:40:18PM +0300, christian.roche.ext@nsn.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@crankycanuck.ca
"The year's penultimate month" is not in truth a good way of saying
November.
		--H.W. Fowler



view thread (6+ messages)

Message-ID: <20070604131230.GI32320@phlogiston.dyndns.org>
Permalink:  ../20070604131230.GI32320@phlogiston.dyndns.org/
Also on:    postgresql.org/message-id/20070604131230.GI32320@phlogiston.dyndns.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: ajs@crankycanuck.ca
  Subject: Re: Versionning (was: Whole-row comparison)
  In-Reply-To: <20070604131230.GI32320@phlogiston.dyndns.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox