Re: Bug #559: MACADDR type & 00:00:00:00:00:00 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug #559: MACADDR type & 00:00:00:00:00:00
Date
Msg-id 29407.1010767879@sss.pgh.pa.us
Whole thread Raw
In response to Bug #559: MACADDR type & 00:00:00:00:00:00  (pgsql-bugs@postgresql.org)
List pgsql-bugs
pgsql-bugs@postgresql.org writes:
> it's not null, so shouldn't it be retrieving as '00:00:00:00:00:00'?

Yeah, due to some brain-fade on the part of the original implementor,
the code went out of its way to special-case 00:00:00:00:00:00 as
being represented by an empty string.  This was agreed to be broken
and we've changed it for 7.2.  If you like you can drop the 7.2
version of the file mac.c into 7.1; see
http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/mac.c

            regards, tom lane

pgsql-bugs by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: Bug #559: MACADDR type & 00:00:00:00:00:00
Next
From: Michael Meskes
Date:
Subject: Re: ECPG bug in --help