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
