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 C7839D1D767
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  6 Feb 2004 20:15:18 +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 76307-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri,  6 Feb 2004 16:15:13 -0400 (AST)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by svr1.postgresql.org (Postfix) with ESMTP id BAF4BD1D599
	for <pgsql-sql@postgresql.org>; Fri,  6 Feb 2004 16:15:11 -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 i16KFB1Y061864
	for <pgsql-sql@postgresql.org>; Fri, 6 Feb 2004 20:15:11 GMT
	(envelope-from news@news.hub.org)
Received: (from news@localhost)
	by news.hub.org (8.12.9/8.12.9/Submit) id i16KDAFc061384
	for pgsql-sql@postgresql.org; Fri, 6 Feb 2004 20:13:10 GMT
Date: Fri, 06 Feb 2004 14:17:11 -0600
From: Chris Fisher <essensus@comcast.net>
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
MIME-Version: 1.0
X-Newsgroups: comp.databases.postgresql.sql
Subject: Re: Storing a range of numbers
References: <zLCdnc4jaOBsLr_dRVn-tw@comcast.com> <c006d6$28dn$1@news.hub.org>
In-Reply-To: <c006d6$28dn$1@news.hub.org>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <tO6dnRFl-efLaL7dRVn-gw@comcast.com>
Lines: 16
X-Complaints-To: abuse@comcast.net
X-DMCA-Complaints-To: dmca@comcast.net
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint
	properly
X-Postfilter: 1.1
To: pgsql-sql@postgresql.org
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200402/70
X-Sequence-Number: 16761



CoL wrote:

> 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.

I thought about using an array but it seems overly complicated for what 
I'm doing.  Two rows will work fine ... a numeric range type seemed 
obvious at the time so I figured I just missed it in the documentation 
or something.

Thanks for the reply.

Chris