X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 94314534DC for ; Wed, 13 Apr 2005 09:54:59 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 19524-10 for ; Wed, 13 Apr 2005 12:54:53 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id D8BEA534D2 for ; Wed, 13 Apr 2005 09:54:52 -0300 (ADT) Received: (qmail 4867 invoked by uid 500); 13 Apr 2005 13:14:10 -0000 Date: Wed, 13 Apr 2005 08:14:10 -0500 From: Bruno Wolff III To: "Ilya A. Kovalenko" Cc: pgsql-sql@postgresql.org Subject: Re: operating "inet" type Message-ID: <20050413131410.GA4594@wolff.to> Mail-Followup-To: Bruno Wolff III , "Ilya A. Kovalenko" , pgsql-sql@postgresql.org References: <14038968283.20050412203404@oganer.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <14038968283.20050412203404@oganer.net> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.01 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/183 X-Sequence-Number: 21076 On Tue, Apr 12, 2005 at 20:34:04 +0800, "Ilya A. Kovalenko" wrote: > > You can do integer compare two "inet" values, but you can't do > integer increment (i.e. increment inet value by integer). It would probably be useful to have some way of generating a list of addresses in a subnet. Being able to increment addresses and having a way to get the highest and lowest addresses in a subnet would give you a way to do that. > I understand, that developers has more important things to do, but > they left "inet" type w/o any ways to work w/ it. You can write your own functions to do this. It is possible that they could go back into the code base if they seem generally useful. If you are interested in getting them back into the code base, you are probably best off proposing specs for the functions on the hackers lists for comments, before writing them.