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