Re: BUG #1517: SQL interval syntax is accepted by the parser, - Mailing list pgsql-bugs

Roy Badami wrote:
>     Bruce>     select interval day to second '1 day 1 hour'
>
>     Bruce> However, we don't support that syntax, only the one with
>     Bruce> the specification after.
>
> Is that valid ANSI SQL?

No idea.  It just seemed like the data type specification and the data
value specification has to be split apart somehow.  Right now we use the
clause after the string as the date type specification, and I see you
saying that the data value specification has to after the string.  Is
that correct?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073