ECPG cursor examples should include EXEC SQL WHENEVER NOT FOUND CONTINUE; after the while loop

2021-07-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/ecpg-variables.html Description: Without this line: EXEC SQL WHENEVER NOT FOUND CONTINUE; after the while(1), I find that ECPG CURSOR examples fail. For example, this example under 36.4.4

Second-granular timezone offset format not documented

2021-07-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-formatting.html Description: I would like to request additional documentation on the timezone format that can be returned. Context: I had a problem with the HDBC-postgresql libra

Re: Second-granular timezone offset format not documented

2021-07-04 Thread Tom Lane
PG Doc comments form writes: > Here is an example of a format that I don't think the documentation > currently covers: > janus=> set timezone to 'America/Mexico_City'; > SET > janus=> select '1920-12-25' :: timestamptz; > timestamptz > -- > 1920-12-2

Re: Second-granular timezone offset format not documented

2021-07-04 Thread Thomas Munro
On Mon, Jul 5, 2021 at 9:56 AM PG Doc comments form wrote: > Note how the response has a very weird timezone offset. I guess it is valid, As for whether it's valid, that's coming from the IANA tz dataset. It has a moment that it believes standard time to have begun at each location, in this case