RE: MACADDR types NULL value (undocumented?)

From: "Mayers, Philip J" <p(dot)mayers(at)ic(dot)ac(dot)uk>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: RE: MACADDR types NULL value (undocumented?)
Date: 2001-03-26 16:15:27
Message-ID: A0F836836670D41183A800508BAF190B35E47E@icex1.cc.ic.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: 26 March 2001 16:05
To: Mayers, Philip J
Cc: 'pgsql-general(at)postgresql(dot)org'
Subject: Re: [GENERAL] MACADDR types NULL value (undocumented?)

"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

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Lockhart 2001-03-26 16:18:33 Re: Re: Call for platforms
Previous Message Tom Lane 2001-03-26 15:27:22 Re: Hi