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.
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match