Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 83E9A1337B96 for ; Sun, 2 Jan 2011 09:17:28 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 57489-06 for ; Sun, 2 Jan 2011 13:17:21 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mailout-de.gmx.net [213.165.64.23]) by mail.postgresql.org (Postfix) with SMTP id 093D91337B98 for ; Sun, 2 Jan 2011 09:17:20 -0400 (AST) Received: (qmail invoked by alias); 02 Jan 2011 13:17:19 -0000 Received: from a88-115-218-165.elisa-laajakaista.fi (EHLO [10.0.0.101]) [88.115.218.165] by mail.gmx.net (mp019) with SMTP; 02 Jan 2011 14:17:19 +0100 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX18Z2Ow7issZiMdZU3mldyt5cUQySOLst9fyfjrgSt kZ2RbezgoZSQ4J Subject: Re: [BUGS] BUG #5662: Incomplete view From: Peter Eisentraut To: pgsql-hackers@postgresql.org Cc: saera87@hotmail.com, Tom Lane In-Reply-To: <1291639622.10677.12.camel@vanquo.pezone.net> References: <201009190941.o8J9fT6H048689@wwwmaster.postgresql.org> <1284918458.20510.0.camel@vanquo.pezone.net> <6630.1284920898@sss.pgh.pa.us> <1291639622.10677.12.camel@vanquo.pezone.net> Content-Type: text/plain; charset="UTF-8" Date: Sun, 02 Jan 2011 15:17:18 +0200 Message-ID: <1293974238.5984.15.camel@vanquo.pezone.net> Mime-Version: 1.0 X-Mailer: Evolution 2.30.3 Content-Transfer-Encoding: 8bit X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201101/70 X-Sequence-Number: 177907 On mån, 2010-12-06 at 14:47 +0200, Peter Eisentraut wrote: > On sön, 2010-09-19 at 14:28 -0400, Tom Lane wrote: > > Or maybe we could implement that function, call it like this > > > > CAST((pg_sequence_parameters(c.oid)).max_value AS > > cardinal_number) AS maximum_value, > > > > and plan on optimizing the view when we get LATERAL. > > Here is an implementation of that. Committed.