On Thu, 27 Jul 2000, Bruce Momjian wrote:
> > 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.
sounds to me like a contrib item too ...
> > 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, Pennsylvania 19026
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org