Re: BUG #18445: date_part / extract range for hours do not match documentation - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #18445: date_part / extract range for hours do not match documentation
Date
Msg-id CAKFQuwZs3WPRuTSm8xkJn-V-gWY-kyJXmb7vcb7CwtuZn08c4w@mail.gmail.com
Whole thread Raw
In response to Re: BUG #18445: date_part / extract range for hours do not match documentation  (Marek Läll <lall.marek@gmail.com>)
Responses Re: BUG #18445: date_part / extract range for hours do not match documentation
List pgsql-bugs
On Friday, April 26, 2024, Marek Läll <lall.marek@gmail.com> wrote:
Hi!

psql (16.2, server 15.5) gives the following responses.
Time handling looks quite inconsistent.

That’s probably a fair assessment.

My opinion is that example 2 is the only one which gives the correct result. Examples 1 and 3 should report errors as well.

We tend not to introduce breaking changes if the only motivation is to be consistent.

David J.

pgsql-bugs by date:

Previous
From: Marek Läll
Date:
Subject: Re: BUG #18445: date_part / extract range for hours do not match documentation
Next
From: "Kumar, Devesh"
Date:
Subject: DETAIL: pg_rewind: servers diverged at WAL location 0/9000000 on timeline 1