macaddr format fix - Mailing list pgsql-patches

From Mike Wyer
Subject macaddr format fix
Date
Msg-id Pine.LNX.4.42.0206062232251.13015-200000@kungfu.doc.ic.ac.uk
Whole thread Raw
Responses Re: macaddr format fix  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: macaddr format fix  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Hi,

The macaddr datatype understands most formats of MAC address, except 12
hex digits with no separators, eg 00AABBCCDDEE
This is easily remedied with the following patch (against 7.2.1):

--- src/backend/utils/adt/mac.c.old     Tue May 28 16:48:34 2002
+++ src/backend/utils/adt/mac.c Tue May 28 16:49:47 2002
@@ -39,6 +39,8 @@

        count = sscanf(str, "%x:%x:%x:%x:%x:%x", &a, &b, &c, &d, &e,
&f);
        if (count != 6)
+               count = sscanf(str, "%2x%2x%2x%2x%2x%2x", &a, &b, &c,
&d, &e, &f);
+       if (count != 6)
                count = sscanf(str, "%x-%x-%x-%x-%x-%x", &a, &b, &c, &d,
&e, &f);
        if (count != 6)
                count = sscanf(str, "%2x%2x%2x:%2x%2x%2x", &a, &b, &c,
&d, &e, &f);

########################## END ########################################

It simply adds two lines to the current checks, and works very well.

Cheers,
Mike Wyer
--
Mike Wyer <mw@doc.ic.ac.uk>     ||         "Woof?"
http://www.doc.ic.ac.uk/~mw     ||  Gaspode the Wonder Dog
Work:  +44 020 7594 8440        ||
Mobile: +44 07900 897543        ||  ICQ: 43922064

Attachment

pgsql-patches by date:

Previous
From: Bill Huang
Date:
Subject: Re: Chinese GB18030 support is implemented!
Next
From: Tatsuo Ishii
Date:
Subject: Re: Chinese GB18030 support is implemented!