Re: MACADDR types NULL value (undocumented?)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mayers, Philip J" <p(dot)mayers(at)ic(dot)ac(dot)uk>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: MACADDR types NULL value (undocumented?)
Date: 2001-03-26 15:05:14
Message-ID: 28459.985619114@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Mayers, Philip J" <p(dot)mayers(at)ic(dot)ac(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message fabrizio.ermini 2001-03-26 15:18:01 Re: Free PostgreSQL Database Hosting - Needs Beta Testers
Previous Message Mayers, Philip J 2001-03-26 14:56:05 RE: MACADDR types NULL value (undocumented?)