X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 09962D1D283 for ; Fri, 6 Feb 2004 14:15:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 10087-09 for ; Fri, 6 Feb 2004 10:15:10 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id EE7D0D1D269 for ; Fri, 6 Feb 2004 10:15:06 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i16EF51a079338 for ; Fri, 6 Feb 2004 14:15:05 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i16DtqLo075259 for pgsql-sql@postgresql.org; Fri, 6 Feb 2004 13:55:52 GMT From: CoL X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Storing a range of numbers Date: Fri, 06 Feb 2004 14:56:01 +0100 Organization: Hub.Org Networking Services Lines: 14 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Accept-Language: en-us, en In-Reply-To: To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/71 X-Sequence-Number: 16762 hi, Chris Fisher wrote: > Hi, > > Is it possible to store a numeric range in a row and query for it, or > would I have to use two rows containing the minimum and maximum limits? or you can have one column, with array type. than the first element is the min value the second is the max:) Question is: is it good for your applications or not, how woud you use it, etc. C.