| From: | "Andrey M(dot) Borodin" <x4mmm(at)yandex-team(dot)ru> |
|---|---|
| To: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> |
| Cc: | Przemysław Sztoch <przemyslaw(at)sztoch(dot)pl>, John Naylor <johncnaylorls(at)gmail(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: date_trunc function in interval version |
| Date: | 2024-03-04 06:38:01 |
| Message-ID: | 3B71F299-B9AD-4DE9-967A-44128129F3EE@yandex-team.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> On 18 Feb 2024, at 05:29, Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> wrote:
>
> I'm not very familiar with date_bin(), but is this issue inherent or
> could we maybe fix date_bin() to handle DST better?
>
> In particular, isn't part of the problem that date_bin() is defined only
> for timestamp and not for timestamptz? Also, date_trunc() allows to
> specify a timezone, but date_bin() does not.
>
>
> In any case, the patch needs to add the new stuff to the SGML docs (to
> doc/src/sgml/func.sgml), which now documents the date_trunc(text,...)
> variant only.
Hi Przemysław,
Please address above notes.
I’ve flipped CF entry [0] to “Waiting on author”, feel free to switch it back.
Thank you!
Best regards, Andrey Borodin.
[0] https://commitfest.postgresql.org/47/4761/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrey M. Borodin | 2024-03-04 06:47:21 | Re: Improving EXPLAIN's display of SubPlan nodes |
| Previous Message | Andrey M. Borodin | 2024-03-04 06:26:21 | Re: Add Index-level REINDEX with multiple jobs |