Skip site navigation (1) Skip section navigation (2)

Missing information on Expressional Indexes

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 (view raw or flat)
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

Responses

pgsql-docs by date

Next:From: Fujii MasaoDate: 2010-03-17 02:28:58
Subject: The type of ssl_renegotiation_limit
Previous:From: Tim LandscheidtDate: 2010-03-14 18:19:20
Subject: OLD and NEW in PL/pgSQL triggers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group