Thread: Re: Storing a range of numbers

Re: Storing a range of numbers

From
Chris Fisher
Date:

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


Re: Storing a range of numbers

From
Tom Lane
Date:
Chris Fisher <essensus@comcast.net> writes:
> ... a numeric range type seemed 
> obvious at the time so I figured I just missed it in the documentation 
> or something.

The "seg" datatype implemented by contrib/seg might be what you want.
        regards, tom lane