Thread: Numeric Columns

Numeric Columns

From
miwalsh
Date:
I need to make a column that is capable of holding numeric values along with 
certain modifiers such as "<" or ">". The column needs to be searchable by 
numbers. For example, if someone searches for values lower than 10.0 the 
column should return the relevant values. However, the column needs to be able 
to hold values like "<0.05".

Is this possible or do I have to change the schema?



Re: Numeric Columns

From
Tom Lane
Date:
miwalsh <miwalsh@vt.edu> writes:
> I need to make a column that is capable of holding numeric values along with 
> certain modifiers such as "<" or ">". The column needs to be searchable by 
> numbers. For example, if someone searches for values lower than 10.0 the 
> column should return the relevant values. However, the column needs to be able 
> to hold values like "<0.05".

contrib/seg might do more or less what you're looking for, but none of
the standard datatypes will.
        regards, tom lane