public inbox for [email protected]
help / color / mirror / Atom feedMissing information on Expressional Indexes
2+ messages / 2 participants
[nested] [flat]
* Missing information on Expressional Indexes
@ 2010-03-17 00:14 David Fetter <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: David Fetter @ 2010-03-17 00:14 UTC (permalink / raw)
To: 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 <[email protected]> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: [email protected]
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Missing information on Expressional Indexes
@ 2010-03-17 04:47 Tom Lane <[email protected]>
parent: David Fetter <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2010-03-17 04:47 UTC (permalink / raw)
To: David Fetter <[email protected]>; +Cc: pgsql-docs
David Fetter <[email protected]> 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-03-17 04:47 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-03-17 00:14 Missing information on Expressional Indexes David Fetter <[email protected]>
2010-03-17 04:47 ` Tom Lane <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox