Re: Mysteries of the future

2024-04-11 Thread Tom Lane
"David G. Johnston" writes: > The request is to fix our documentation to use a valid date for the example > in the paragraph that describes the separator requirement for years greater > than 4 digits. Oh! Got it, that should be fixed. regards, tom lane

Re: Mysteries of the future

2024-04-11 Thread David G. Johnston
On Thu, Apr 11, 2024 at 7:20 AM Tom Lane wrote: > PG Doc comments form writes: > > SELECT to_date('2-1131', '-MMDD'); > > ERROR: 22008: date/time field value out of range: "2-1131" > > What exactly do you find wrong with that? November doesn't have > 31 days. > > Sure, we could hav

Re: Mysteries of the future

2024-04-11 Thread Tom Lane
PG Doc comments form writes: > SELECT to_date('2-1131', '-MMDD'); > ERROR: 22008: date/time field value out of range: "2-1131" What exactly do you find wrong with that? November doesn't have 31 days. Sure, we could have a discussion about the probability of the Gregorian calendar s

Mysteries of the future

2024-04-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/functions-formatting.html Description: I'm not sure that there will be 31 days in 11 months; although postgresql probably knows better what will happen in 2 For example (with the yea