Skip site navigation (1) Skip section navigation (2)

Re: Summary: what to do about INET/CIDR

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alex Pilosov <alex(at)pilosoft(dot)com>, pgsql-hackers(at)postgresql(dot)org, Peter Eisentraut <peter_e(at)gmx(dot)net>
Subject: Re: Summary: what to do about INET/CIDR
Date: 2000-10-28 03:06:12
Message-ID: 20001027220612.B12357@lerami.lerctr.org (view raw or flat)
Thread:
Lists: pgsql-hackers
* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [001027 21:53]:
> >>>> e) have a function network(inet) which would look up the address in a
> >>>> table of networks using longest-prefix-match. I.E. something similar to:
> 
> >> No need.  Let the user do it themselves. Similar to what we did for
> >> macaddr's back in the summer. 
> 
> > Yeah, it can be user-defined (or a contrib), no question about it, and for
> > people who have more than one table of networks, it will _have_ to be
> > user-defined.
> 
> It seems clear to me that this mapping is best left to the user.
> 
> A more interesting question is whether the system needs to provide any
> assisting functions that aren't there now.  The lookup function you guys
> are postulating seems like it would be (in the simple cases)
> 	create function my_network(inet) returns cidr as
> 	'select network from my_networks where ???'
> Maybe it's too late at night, but I'm having a hard time visualizing
> what the ??? condition is and whether any additional system-level
> functions are needed to make it simple/efficient.
I don't think we need this ASAP for 7.1.  Let's get the basic stuff
working from a "least surprise" standpoint, and see what the user base
comes up with.  I really think your proposal from earlier tonite is
the way to go, at least from my perspective. 

Thanks again.

LER

> 
> 			regards, tom lane
-- 
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

In response to

Responses

pgsql-hackers by date

Next:From: Alex PilosovDate: 2000-10-28 03:08:58
Subject: Re: Summary: what to do about INET/CIDR
Previous:From: Larry RosenmanDate: 2000-10-28 03:04:39
Subject: Re: Summary: what to do about INET/CIDR

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group