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

hdb=> explain select * from host where mac = '00:00:00:00:00:00';

Seq Scan on host  (cost=0.00..460.62 rows=1793 width=62)

hdb=> explain select * from host where mac = '00:00:00:00:00:01';

Index Scan using host_mac on host  (cost=0.00..145.07 rows=179 width=62)



I take it that:

1) 00:00:00:00:00:00 is interpreted as NULL for MACADDR types (grr...)
2) NULL tests aren't optimised by indices (I know this already)

This should be added to the documentation. I'm going to have to use a
different value for my NULL, since I will need to be indexing those...

Regards,
Phil

+----------------------------------+
| Phil Mayers, Network Support     |
| Centre for Computing Services    |
| Imperial College                 |
+----------------------------------+