Comment by LittlePeter

In my opinion BETWEEN should not be used because it is not clear whether the boundaries are open or closed.

See also https://wiki.postgresql.org/wiki/Don%27t_Do_This#Don.27t_use...