Re: BUG #1517: SQL interval syntax is accepted by the parser,

Roy Badami wrote:
>
>     Bruce> This is going to be a backward compatibility problem, but
>     Bruce> to support ANSI syntax we are going to need to do this.
>
> Given the existence of the INTERVAL '1' MONTH etc syntax is completely
> undocumented, I doubt it's a major problem.
>
> (Actually, INTERVAL '1' and INTERVAL '1:30' are undocumented, too, but
> it's probably more likely that people are relying on that).

Yes, I am thinking that interval strings that contain letters are going
to be PG, and anything else is ANSI.

--
  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