Ok, how would one set this up (I've NEVER programmed in PG's backend,
so I'm a little skittish).
The changes I did for mac.c were obvious, so I'm afraid of breaking
PG's world.
Anything I can do?
Larry
> > I was thinking of making the following:
> > 1) macaddr_manuf function that returns the first 3 octets of a macaddr
> > 2) a macaddr_manuf TYPE that can be used for the table
> > 3) supply the ouiparse.awk to generate a set of INSERT statements
> > to load a table
> > 4) allow the above table to be indexed.
>
> Why not use a comparison function which knows how to compare just the
> manufacturer's id fields? Or define a function which masks a mac address
> to return the id fields and zeros everywhere else (so you can then use
> the "normal" comparison functions)?
>
> Defining a new type to allow this masking and comparison seems more than
> necessary (which, if this argument holds up, would make it undesirable).
> We can still define functional indices so that a table lookup will be
> fast in any case.
>
> - Thomas
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 (voice) Internet: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
