Re: Storing a range of numbers

From: CoL <col(at)mportal(dot)hu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Storing a range of numbers
Date: 2004-02-06 13:56:01
Message-ID: c006d6$28dn$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-02-06 14:55:28 Re: Seq scan on zero-parameters function
Previous Message Tomasz Myrta 2004-02-06 11:46:04 Re: alias problem on join