| From: | Shvidky Andrey <andrey_shvidky(at)hotmail(dot)com> |
|---|---|
| To: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | daterange constructor vs cast |
| Date: | 2023-12-11 16:14:38 |
| Message-ID: | AM9P195MB09039825DC2F6BC4F13A78C8E78FA@AM9P195MB0903.EURP195.PROD.OUTLOOK.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2023-12-11 17:04:13 | Re: daterange constructor vs cast |
| Previous Message | Tom Lane | 2023-12-11 15:05:53 | Re: BUG #18240: Undefined behaviour in cash_mul_flt8() and friends |