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:[EMAIL PROTECTED]] Sent: 26 March 2001 16:05 To: Mayers, Philip J Cc: '[EMAIL PROTECTED]' Subject: Re: [GENERAL] MACADDR types NULL value (undocumented?) "Mayers, Philip J" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
