+2 votes
in Databases by (11k 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

0 votes
by (15.1k points)

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;

...