Postgres Pro
Downloads
Home   >   mailing lists

Re: Missing information on Expressional Indexes - Mailing list pgsql-docs

From Tom Lane
Subject Re: Missing information on Expressional Indexes
Date
Msg-id 20306.1268801271@sss.pgh.pa.us
Whole thread Raw
In response to Missing information on Expressional Indexes  (David Fetter <david@fetter.org>)
List pgsql-docs
Tree view 
David Fetter <david@fetter.org> writes:
> 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.

Sure they do, see CREATE INDEX:

    All functions and operators used in an index definition must be
    "immutable" ...

            regards, tom lane

pgsql-docs by date:

Previous
From: Fujii Masao
Date:
Subject: The type of ssl_renegotiation_limit
Next
From: Josh Kupershmidt
Date:
Subject: Incorrect SQL on CREATE INDEX page