Postgres Pro
Downloads
Home   >   mailing lists

Quick question regarding indexes and NULLs in 7.3.3 -> 7.4 - Mailing list pgsql-sql

From Josh Berkus
Subject Quick question regarding indexes and NULLs in 7.3.3 -> 7.4
Date
Msg-id 200305251511.47341.josh@agliodbs.com
Whole thread Raw
Responses Re: Quick question regarding indexes and NULLs in 7.3.3 -> 7.4  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Markus Bertheau
Date:
Subject: Re: select lower('ÆØÅ ABC'); does
Next
From: Tom Lane
Date:
Subject: Re: Quick question regarding indexes and NULLs in 7.3.3 -> 7.4