Re: Date-Time dangling unit fix
Joseph Koshakow <koshy44@gmail.com>
From: Joseph Koshakow <koshy44@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2022-12-11T15:41:27Z
Lists: pgsql-hackers
Attachments
- v1-0001-Handle-dangling-units-in-date-time-input.patch (text/x-patch) patch v1-0001
On Sun, Dec 11, 2022 at 10:29 AM Joseph Koshakow <koshy44@gmail.com> wrote: > > Hi all, > > Attached is a patch to fix a parsing error for date-time types that > allow dangling units in the input. For example, > `date '1995-08-06 m y d'` was considered a valid date and the dangling > units were ignored. > > Intervals also suffer from a similar issue, but the attached patch > doesn't fix that issue. For example, > `interval '1 day second month 6 hours days years ago'` is parsed as a > valid interval with -1 days and -6 hours. I'm hoping to fix that in a > later patch, but it will likely be more complicated than the other > date-time fixes. > > - Joe Koshakow I think I sent that to the wrong email address.
Commits
-
Tighten error checks in datetime input, and remove bogus "ISO" format.
- 5b3c5953553b 16.0 landed
-
Measure the current transaction time to milliseconds.
- 6f58115dddfa 7.2.1 cited