Re: mac.c

> It'd be nice (tm). I am using mac address types now, and certainly going
> to be upset if they just disappear in next postgres version :P)

No, I don't recommend removing the macaddr type. It is fine in the main
tree. It is just the function that maps ethernet address to
manufacturer that I am questioning.

>
> However, this is definitely a contrib feature, not a core postgres item.
>
> Probably the macaddr type should be also moved to that contrib directory.
>
> I suggest that the contrib would include a query that creates mac_manuf
> table and a 'macaddr_manuf(macaddr) returns varchar' function which would
> do a 'select name from mac_manuf m where m.mac=mac_trunc(macaddr)' and a
> 'mac_trunc(macaddr) returns macaddr' which would set the 3 lowest-order
> nibbles to 0.
>
> (I don't think macmanufacturer deserves a separate type).

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026