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

Postgres_FDW doc doesn't specify TYPE support in Remote Execution Options

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/postgres-fdw.html Description: Hi, The https://www.postgresql.org/docs/current/postgres-fdw.html#POSTGRES-FDW-OPTIONS-REMOTE-EXECUTION section mentions for `extensions` configuration optio

Re: Postgres_FDW doc doesn't specify TYPE support in Remote Execution Options

2024-04-11 Thread Rajan Pandey
Hi, please ignore my last email about the patch. :/ I have determined that pushdown of custom data types through fdw in fact does make sense. Consider this query: SELECT * FROM customers WHERE ; To push down the WHERE clause to the foreign servers, both local and foreign server must have the u

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