Robert Haas <robertmh...@gmail.com> writes: > On Mon, Jun 13, 2016 at 12:25 PM, Robert Haas <robertmh...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers