Hello!
Aren’t these 6 results must be the same?
select
daterange('[20231211', '20231211]')
,daterange('[20231211', '20231212)')
,daterange('20231211', '20231211', '[]')
,daterange('20231211', '20231212', '[)')
,'[20231211,20231211]'::daterange
,'[20231211,20231212)'::daterange
daterange|daterange |daterange |daterange |daterange |daterange |
---------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+
empty |[2023-12-11,2023-12-12)|[2023-12-11,2023-12-12)|[2023-12-11,2023-12-12)|[2023-12-11,2023-12-12)|[2023-12-11,2023-12-12)|
Thanks in advance!
Andrey N. Shvidky.