Numeric Columns

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Numeric Columns

miwalsh
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?


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
Reply | Threaded
Open this post in threaded view
|

Re: Numeric Columns

Tom Lane-2
miwalsh <[hidden email]> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org