Received: from maynard.mail.mindspring.net (maynard.mail.mindspring.net [207.69.200.243]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBD1dMm92870 for ; Wed, 12 Dec 2001 20:39:22 -0500 (EST) (envelope-from mislam@mindspring.com) Received: from jupiter.sjc.mindspring.net ([199.174.215.17] helo=jupiter) by maynard.mail.mindspring.net with smtp (Exim 3.33 #1) id 16EKqL-0000wh-00 for pgsql-sql@postgresql.org; Wed, 12 Dec 2001 20:39:25 -0500 Message-ID: <001b01c18376$dcdb8c80$0100a8c0@sjc.mindspring.net> From: "Mir S Islam" To: Subject: cidr question Date: Wed, 12 Dec 2001 17:38:27 -0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200112/144 X-Sequence-Number: 5967 maybe I am not understanding it right. Here is my problem. I have a table like this Attribute | Type | Modifier --------------+--------------------------+---------- ip | cidr | not null with following rows ip --------------- 10.0.0.1/32 10.0.0.50/32 10.0.0.255/32 11.0.0.0/32 11.0.1.200/32 11.0.1.20/32 (6 rows) should not the command DELETE from ip_space where ip = '11.0.1.0/24'::cidr delete last two rows ? But it does not delete anything. Basically I would like to be able to delete a whole range or block of ip/network addresses. I suppose I could rewrite the above sql as delete from ip_space where ip >='11.0.1.0/24'::cidr and ip <='11.0.2.0/24'::cidr; Then it works. But I should not have to do that. Right ? Thanks in advance. Please email and post here. Mir