Re: Date-Time dangling unit fix - Mailing list pgsql-hackers

From Joseph Koshakow
Subject Re: Date-Time dangling unit fix
Date
Msg-id CAAvxfHf++UNBoYua8AQkwM3MCpLszOBeug-2F9PjD79mrW5SDA@mail.gmail.com
Whole thread Raw
In response to Date-Time dangling unit fix  (Joseph Koshakow <koshy44@gmail.com>)
Responses Re: Date-Time dangling unit fix  (Joseph Koshakow <koshy44@gmail.com>)
List pgsql-hackers
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.

Attachment

pgsql-hackers by date:

Previous
From: Joseph Koshakow
Date:
Subject: Date-Time dangling unit fix
Next
From: Tom Lane
Date:
Subject: Re: Error-safe user functions