Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id C98E47986F1 for ; Tue, 16 Mar 2010 21:43:55 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 58467-02 for ; Wed, 17 Mar 2010 00:43:36 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from fetter.org (start.fetter.org [66.92.188.65]) by mail.postgresql.org (Postfix) with ESMTP id 8E7527986FA for ; Tue, 16 Mar 2010 21:14:03 -0300 (ADT) Received: by fetter.org (Postfix, from userid 500) id D3BB1FBC982; Tue, 16 Mar 2010 17:14:01 -0700 (PDT) Date: Tue, 16 Mar 2010 17:14:01 -0700 From: David Fetter To: PostgreSQL Docs Subject: Missing information on Expressional Indexes Message-ID: <20100317001401.GJ21279@fetter.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.20 (2009-08-17) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.413 tagged_above=-10 required=5 tests=AWL=1.186, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/7 X-Sequence-Number: 5372 Folks, I think this page should mention that the expressions used in an expressional index need to be equivalent to an IMMUTABLE function, and the docs don't say so. The change should also be back-patched. I'm thinking that something along the lines of, "Expressions are limited to those which are equivalent to an [link]IMMUTABLE[/link] function." Anybody have a better suggestion for wording? Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate