Re: Date-Time dangling unit fix

From: Joseph Koshakow <koshy44(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Date-Time dangling unit fix
Date: 2022-12-11 15:41:27
Message-ID: CAAvxfHf++UNBoYua8AQkwM3MCpLszOBeug-2F9PjD79mrW5SDA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Dec 11, 2022 at 10:29 AM Joseph Koshakow <koshy44(at)gmail(dot)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 Content-Type Size
v1-0001-Handle-dangling-units-in-date-time-input.patch text/x-patch 7.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2022-12-11 17:24:11 Re: Error-safe user functions
Previous Message Joseph Koshakow 2022-12-11 15:29:23 Date-Time dangling unit fix