Re: [HACKERS] CIDR type and functions
От | Bruce Momjian |
---|---|
Тема | Re: [HACKERS] CIDR type and functions |
Дата | |
Msg-id | 199810091935.PAA25363@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: [HACKERS] CIDR type and functions (darcy@druid.net (D'Arcy J.M. Cain)) |
Ответы |
Re: [HACKERS] CIDR type and functions
|
Список | pgsql-hackers |
> Thus spake Bruce Momjian > > Check \df and \fo. There is a >> and << operators that do subnet > > testing. > > [I assume you meant \do] > > Cool. I checked out what other functions as well. I don't see a couple > that were discussed early on though. Specifically, how about functions > to extract the host, the network or the netmask from an address? > > Here are the functions I had suggested. > > netmask('192.3.4.5/24::cidr') == 255.255.255.0 > masklen('192.3.4.5/24::cidr') == 24 > host('192.3.4.5/24::cidr') == 192.3.4.5 > network('192.3.4.5/24::cidr') == 192.3.4.0 > > and perhaps; > > class('192.3.4.5/24::cidr') == C > classnet('192.3.4.5/24::cidr') == 192.3.4 > > Can I help code up some of this stuff? Yes, we need those. Code them up, and I will add them as standard types. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
В списке pgsql-hackers по дате отправления: