Re: [HACKERS] CIDR type and functions
От | darcy@druid.net (D'Arcy J.M. Cain) |
---|---|
Тема | Re: [HACKERS] CIDR type and functions |
Дата | |
Msg-id | m0zRh5F-0000exC@druid.net обсуждение исходный текст |
Ответ на | Re: [HACKERS] CIDR type and functions (Bruce Momjian <maillist@candle.pha.pa.us>) |
Ответы |
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? -- D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner.
В списке pgsql-hackers по дате отправления: