Re: MACADDR types NULL value (undocumented?) - Mailing list pgsql-general

From Tom Lane
Subject Re: MACADDR types NULL value (undocumented?)
Date
Msg-id 28459.985619114@sss.pgh.pa.us
Whole thread Raw
In response to RE: MACADDR types NULL value (undocumented?)  ("Mayers, Philip J" <p.mayers@ic.ac.uk>)
List pgsql-general
"Mayers, Philip J" <p.mayers@ic.ac.uk> writes:
> I was under the impression that indices aren't used for "IS NULL"

They're not (at present).  But given those numbers you wouldn't want an
indexscan when looking for nulls anyway, so where's the downside?

            regards, tom lane

pgsql-general by date:

Previous
From: "Mark Hamby"
Date:
Subject: Patch (tiny): \cd (change dir) for psql.
Next
From: fabrizio.ermini@sysdat.it
Date:
Subject: Re: Free PostgreSQL Database Hosting - Needs Beta Testers