Received: from smtp6.mindspring.com (smtp6.mindspring.com [207.69.200.110]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBD2Xbm97656 for ; Wed, 12 Dec 2001 21:33:37 -0500 (EST) (envelope-from mislam@mindspring.com) Received: from jupiter.sjc.mindspring.net ([199.174.215.17] helo=jupiter) by smtp6.mindspring.com with smtp (Exim 3.33 #1) id 16ELgr-0003bU-00 for pgsql-sql@postgresql.org; Wed, 12 Dec 2001 21:33:41 -0500 Message-ID: <002d01c1837e$710f7180$0100a8c0@sjc.mindspring.net> From: "Mir S Islam" To: Subject: cidr question (resent) Date: Wed, 12 Dec 2001 18:32:42 -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/125 X-Sequence-Number: 5948 Resending this. Aplogies for duplicates if any. 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