Re: Update: mac.c update, patch now on ftp
От | Larry Rosenman |
---|---|
Тема | Re: Update: mac.c update, patch now on ftp |
Дата | |
Msg-id | 200007200633.e6K6XXL11466@lerami.lerctr.org обсуждение исходный текст |
Ответ на | Re: Update: mac.c update, patch now on ftp (Thomas Lockhart <lockhart@alumni.caltech.edu>) |
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: