Re: mac.c
От | Bruce Momjian |
---|---|
Тема | Re: mac.c |
Дата | |
Msg-id | 200007271300.JAA04830@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: mac.c (Alex Pilosov <alex@pilosoft.com>) |
Ответы |
Re: mac.c
|
Список | pgsql-hackers |
> 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
В списке pgsql-hackers по дате отправления: