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.
>