From: | Larry Rosenman <ler(at)lerctr(dot)org> |
---|---|
To: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
Cc: | Larry Rosenman <ler(at)lerctr(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Update: mac.c update, patch now on ftp |
Date: | 2000-07-18 11:50:25 |
Message-ID: | 200007181150.e6IBoPa25951@lerami.lerctr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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.
What does the group think of this?
Larry Rosenman
> > The code in mac.c does a LINEAR search, and the list is only going to
> > grow. It's at 4110+ OUI's that are PUBLIC.).
>
> Yuck. Let's put it into a (user loadable) table. And rather than having
> macaddr_manuf(), we should just have a "sametype()" (or whatever) which
> can compare an arbitrary mac address with another one. Then
>
> select brand from mactypes where '03:04:...' = macmask;
>
> or at least
>
> select brand from mactypes where sametype('03:04:...',macmask);
>
> would get you the right thing.
>
> I can help with these internals, if that is the right way to head.
>
> - Thomas
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 (voice) Internet: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
From | Date | Subject | |
---|---|---|---|
Next Message | Lamar Owen | 2000-07-18 11:54:41 | Re: Untrusted PL/Tcl? |
Previous Message | Jan Wieck | 2000-07-18 11:36:22 | Untrusted PL/Tcl? |