CIdr query qestion

From: Michele Petrazzo - Unipex srl <michele(dot)petrazzo(at)unipex(dot)it>
To: pgsql-sql(at)postgresql(dot)org
Subject: CIdr query qestion
Date: 2007-07-10 07:36:49
Message-ID: 46933711.4030501@unipex.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 also the abbr or set_masklen keyword,
but the same. How do it?

P.s. Tried the >>, but it only include the values that I want to
exclude! (And I don't found how to do the opposite!)

Thanks,
Michele

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jesper K. Pedersen 2007-07-10 09:00:12 Re: CIdr query qestion
Previous Message Patrick Clery 2007-07-10 06:38:12 Index working, but not inside function