PostgreSQL : How to select value from a column of range type

Question

In a PostgreSQL table, one of the columns has value in range .e.g. [2011-07-31,2011-08-01). I want to select both values separately so that I can apply some operations to those values. How can I select the values?

Answer 1

Try lower() and upper() functions with your query. It should return the values. E.g.

select lower(date_range), upper(date_range) from date_table;