Shvidky Andrey <andrey_shvidky@hotmail.com> writes:
> Aren't these 6 results must be the same?
I think you have the wrong idea of how range constructors work.
This:
> daterange('[20231211', '20231211]')
> ,daterange('[20231211', '20231212)')
is not valid input really. It happens to not fail because date_in
ignores garbage punctuation; but nothing is considering those
brackets or parens as indicating range end types.
These are the approved way to do it:
> ,daterange('20231211', '20231211', '[]')
> ,daterange('20231211', '20231212', '[)')
regards, tom lane