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.