Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 445689FB4F9 for ; Fri, 1 Jun 2007 14:47:33 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 60841-01-5 for ; Fri, 1 Jun 2007 14:47:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 8D4169FC3F4 for ; Fri, 1 Jun 2007 14:47:21 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1HuBDY-0001UA-Jp for pgsql-sql@postgresql.org; Fri, 01 Jun 2007 13:47:16 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 42641404E; Fri, 1 Jun 2007 13:47:11 -0400 (EDT) Date: Fri, 1 Jun 2007 13:47:11 -0400 From: Andrew Sullivan To: pgsql-sql@postgresql.org Subject: Re: Versionning (was: Whole-row comparison) Message-ID: <20070601174711.GH24299@phlogiston.dyndns.org> References: <473557.7523.qm@web31803.mail.mud.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/2 X-Sequence-Number: 28492 On Fri, Jun 01, 2007 at 08:07:46PM +0300, christian.roche.ext@nsn.com wrote: > I've contemplated reusing an awful hack from my Access era, namely using > a single-rowed table to store the parameter and joining the view on it. > The parameter would be updated before the view is called; this would > work but would definitely be ugly. Can someone think of a better way to > do that ? I sort of don't see how that hack would be any different from a SRF. You'd lose the planner benefits anyway, I think, because you'd have to plan for the generic case where the data could be anything, no? A -- Andrew Sullivan | ajs@crankycanuck.ca Users never remark, "Wow, this software may be buggy and hard to use, but at least there is a lot of code underneath." --Damien Katz