Functional Index

From: "Taher H(dot) Haveliwala" <taherh24(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Functional Index
Date: 2001-10-03 22:25:30
Message-ID: 20011003222530.70315.qmail@web13006.mail.yahoo.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

When building an index over the function f() of a
field a, what does postgres store internally in the
index pages: a, or f(a)?

It could be done either way, but it makes a difference
in some tradeoffs that affect me. In particular it
affects space usage, and it affects whether

SELECT a from T WHERE f(a) < foobar

can be answered using purely the index without
touching the underlying heapfile. I couldn't quite
tell what postgres actually does from the docs at

http://postgresql.crimelabs.net/users-lounge/docs/7.1/postgres/indices-functional.html

Thanks in advance
Taher

__________________________________________________
Do You Yahoo!?
NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-10-03 22:31:37 Re: Functional Index
Previous Message Richard Welty 2001-10-03 22:22:40 Re: function/trigger questions