Re: mac.c
От | Alex Pilosov |
---|---|
Тема | Re: mac.c |
Дата | |
Msg-id | Pine.BSO.4.10.10007270003160.4362-100000@spider.pilosoft.com обсуждение исходный текст |
Ответ на | Re: mac.c (Bruce Momjian <pgman@candle.pha.pa.us>) |
Ответы |
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) 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). -alex On Wed, 26 Jul 2000, Bruce Momjian wrote: > > All I want to do now (given the size stuff), is to have a function and > > possibly a type to compare the 24-bit OUI's, and give the tools > > in /contrib to load a table using these from the IEEE's list. > > > > No more hardcoded stuff in the db. > > > > Does this make more sense? > > > > It's definately extensible, and frees code space. > > I was just wondering if there was any real demand for this feature. >
В списке pgsql-hackers по дате отправления: