Re: Bug in to_timestamp(). - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Bug in to_timestamp().
Date
Msg-id 11349.1466429771@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug in to_timestamp().  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Bug in to_timestamp().  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Re: Bug in to_timestamp().  (Alex Ignatov <a.ignatov@postgrespro.ru>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Mon, Jun 13, 2016 at 12:25 PM, Robert Haas <robertmhaas@gmail.com> wrote:
>> I think a space in the format string should skip a whitespace
>> character in the input string, but not a non-whitespace character.
>> It's my understanding that these functions exist in no small part for
>> compatibility with Oracle, and Oracle declines to skip the digit '1'
>> on the basis of an extra space in the format string, which IMHO is the
>> behavior any reasonable user would expect.

> So Amul and I are of one opinion and Tom is of another.  Anyone else
> have an opinion?

I don't necessarily have an opinion yet.  I would like to see more than
just an unsupported assertion about what Oracle's behavior is.  Also,
how should FM mode affect this?
        regards, tom lane



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: parallel.c is not marked as test covered
Next
From: Albe Laurenz
Date:
Subject: Re: Bug in to_timestamp().