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 != > network

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

[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 als