daterange constructor vs cast - Mailing list pgsql-bugs

From Shvidky Andrey
Subject daterange constructor vs cast
Date
Msg-id AM9P195MB09039825DC2F6BC4F13A78C8E78FA@AM9P195MB0903.EURP195.PROD.OUTLOOK.COM
Whole thread Raw
Responses Re: daterange constructor vs cast
List pgsql-bugs

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.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #18240: Undefined behaviour in cash_mul_flt8() and friends
Next
From: Tom Lane
Date:
Subject: Re: daterange constructor vs cast