Re: setting the timezone parameter with space cause diff result

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: 甄明洋 <zhenmingyang(at)yeah(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: setting the timezone parameter with space cause diff result
Date: 2021-06-09 02:46:18
Message-ID: CAKFQuwaiJ-DwpjatbVFpxjGvYmttP-GskRFf6=3vzj3xswEMGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tuesday, June 8, 2021, 甄明洋 <zhenmingyang(at)yeah(dot)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.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2021-06-09 03:20:50 Re: setting the timezone parameter with space cause diff result
Previous Message 甄明洋 2021-06-09 02:27:26 Re:Re: setting the timezone parameter with space cause diff result