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

Related questions