Re: setting the timezone parameter with space cause diff result

David G. Johnston <david.g.johnston@gmail.com>

From: "David G. Johnston" <david.g.johnston@gmail.com>
To: 甄明洋 <zhenmingyang@yeah.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, "pgsql-bugs@postgresql.org" <pgsql-bugs@postgresql.org>
Date: 2021-06-09T02:46:18Z
Lists: pgsql-bugs
On Tuesday, June 8, 2021, 甄明洋 <zhenmingyang@yeah.net> wrote:
>
> Here is an example, which seems to be a problem of parsing, if format
> string with FF and TZH:TZM,  but the datetime string without fractional
> seconds will cause parsing misalignment,
>

Yes, with a template language this complex it is possible that invalid
input will mis-parse instead of provoking an error.  Use regexes if you
need to validate the input format - all the parser should really be relied
upon to do is take a valid input and convert it.

David J.