+2 votes
in Databases by (63.0k points)
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?

1 Answer

+1 vote
by (271k points)
selected by
Best answer

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;