title: Most Efficient Way to Compare String Dates in Postgresql?
body: <p>We have a PostgreSQL DB running on AWS (Engine Version 11.8).<br />
  For each item, we are storing dates as strings [varchar type] (in the following format - '2020-12-16')<br />
  Our app has requirements to do date range queries. Based on that, what is the best and most efficient way to do string date comparisons in PostgreSQL?<br />
  I looked at several questions here on SO, but no one talks about the question if there is a difference to store the dates as type &quot;varchar&quot; or type &quot;date&quot;.<br />
  Also based on the 2 storage types above, what would be the most efficient way to do queries? In particular we are looking at querying for ranges (for example from '2020-12-10' and '2020-12-16')<br />
  Thanks a lot for your feedback</p>