Re: BUG #12872: Inconsistent processing of interval values

On Mon, Mar 16, 2015 at 11:03:52PM +0000, jan.mate@inf-it.com wrote:
> works, but:
>
> testdb=> SELECT (now()-' +5 days -12 hours -1 second +1 day'::interval) AS
> tstz;
> ERROR:  invalid input syntax for type interval: " +5 days -12 hours -1
> second +1 day"
> LINE 1: SELECT (now()-' +5 days -12 hours -1 second +1 day'::interva...
>
> generates an error. Yes, I understand that writing '+5 days +1 day' is
> "stupid" but it conforms the syntax in the documentation.

Well, I think we have always had that restriction, and you are the first
person to mention it.  Are you thinking we should document this
limitation?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +