Re: mac.c

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