[SQL] CIdr query qestion

2007-07-10 Thread Michele Petrazzo - Unipex srl
Hi ml! A question about cidr query. I'm tring to use the various cidr functions to exclude a A sub class, but I don't understand how use it: SELECT count(ip_addr), ip_addr from wi_log_network where ip_addr != network('10.10.0.0/16', 16) group by (ip_addr); it don't exclude the 10.10 ! Tried

Re: [SQL] CIdr query qestion

2007-07-10 Thread Jesper K. Pedersen
On Tue, 10 Jul 2007 09:36:49 +0200 Michele Petrazzo - Unipex srl [EMAIL PROTECTED] wrote: Hi ml! A question about cidr query. I'm tring to use the various cidr functions to exclude a A sub class, but I don't understand how use it: SELECT count(ip_addr), ip_addr from wi_log_network where

Re: [SQL] CIdr query qestion

2007-07-10 Thread Michael Fuhr
On Tue, Jul 10, 2007 at 09:36:49AM +0200, Michele Petrazzo - Unipex srl wrote: A question about cidr query. I'm tring to use the various cidr functions to exclude a A sub class, but I don't understand how use it: SELECT count(ip_addr), ip_addr from wi_log_network where ip_addr !=