How to get the smallest date value in postgres?

Question

PostgreSQL

There is such a condition in sql query:

"Group" >= COALESCE($7 :: INT, -100) AND COALESCE("Group" <= $8 :: INT, 100)

If the parameters $7 and $8 are present, then they set the range of values ​​within which you want to find the rows. It is necessary to make a similar condition for the date field. How can I set the minimum and maximum allowed date value?

Answer 1

postgres can compare dates as well as numbers
and also has a BETWEEN operator