miwalsh <miwalsh(at)vt(dot)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