Quick question regarding indexes and NULLs in 7.3.3 -> 7.4

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Quick question regarding indexes and NULLs in 7.3.3 -> 7.4
Date: 2003-05-25 22:11:47
Message-ID: 200305251511.47341.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Folks,

I'm updating Joy of Index, and I wanted to clear something up. In 7.3.3, and
in 7.4 CVS, will IS NOT NULL queries use a regular index if NULLs are
sufficiently uncommon, or does this still require an IS NULL partial index as
it did in 7.2.x? I don't want to mislead readers ....

--
Josh Berkus
Aglio Database Solutions
San Francisco

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-05-25 22:59:04 Re: Quick question regarding indexes and NULLs in 7.3.3 -> 7.4
Previous Message Rob Wood 2003-05-25 21:44:25 date interpolation