From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | PostgreSQL Docs <pgsql-docs(at)postgresql(dot)org> |
Subject: | Missing information on Expressional Indexes |
Date: | 2010-03-17 00:14:01 |
Message-ID: | 20100317001401.GJ21279@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
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.
<http://www.postgresql.org/docs/current/static/indexes-expressional.html>
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 <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Fujii Masao | 2010-03-17 02:28:58 | The type of ssl_renegotiation_limit |
Previous Message | Tim Landscheidt | 2010-03-14 18:19:20 | OLD and NEW in PL/pgSQL triggers |