Horton

Re: AW: pg_index.indislossy

Thomas Lockhart <lockhart@alumni.caltech.edu>

View thread
From: Thomas Lockhart <lockhart@alumni.caltech.edu>
To: Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
Cc: "'Bruce Momjian'" <pgman@candle.pha.pa.us>, The Hermit Hacker <scrappy@hub.org>, Hannu Krosing <hannu@tm.ee>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2001-05-15T12:40:51Z
Lists: pgsql-hackers 
> > Yea, there is actually some code attached to this vs. the others that
> > had no code at all.  Are we ever going to do partial indexes?  I guess
> > that is the question.
> The idea is very very good, and since there is an exaple implementation in
> pg 4 it should probably be possible to reimplement. (DB2 has this feature also)
...
> Imho it would be a shame to give up that idea so easily.

Agreed. Another common example is to create an index on all non-null
values of a column.

                    - Thomas