Good point - thanks for the advice
(Tom - where *do* you get the time to answer everyones questions? :o)
Regards,
Phil
+----------------------------------+
| Phil Mayers, Network Support |
| Centre for Computing Services |
| Imperial College |
+----------------------------------+
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: 26 March 2001 16:05
To: Mayers, Philip J
Cc: 'pgsql-general@postgresql.org'
Subject: Re: [GENERAL] MACADDR types NULL value (undocumented?)
"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