Re: [SQL] Storing a range of numbers

2004-02-07 Thread Tom Lane
Chris Fisher <[EMAIL PROTECTED]> 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 --

Re: [SQL] Storing a range of numbers

2004-02-07 Thread CoL
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

Re: [SQL] Storing a range of numbers

2004-02-07 Thread Chris Fisher
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