> 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@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026