Re: setting the timezone parameter with space cause diff result - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: setting the timezone parameter with space cause diff result
Date
Msg-id CAKFQuwaiJ-DwpjatbVFpxjGvYmttP-GskRFf6=3vzj3xswEMGA@mail.gmail.com
Whole thread Raw
In response to Re:Re: setting the timezone parameter with space cause diff result  (甄明洋 <zhenmingyang@yeah.net>)
Responses Re: setting the timezone parameter with space cause diff result  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.

pgsql-bugs by date:

Previous
From: 甄明洋
Date:
Subject: Re:Re: setting the timezone parameter with space cause diff result
Next
From: Tom Lane
Date:
Subject: Re: setting the timezone parameter with space cause diff result