| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Roy Badami <roy(at)gnomon(dot)org(dot)uk> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #1517: SQL interval syntax is accepted by the parser, |
| Date: | 2005-03-23 22:14:14 |
| Message-ID: | 200503232214.j2NMEE320357@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-03-23 22:24:35 | Re: BUG #1517: SQL interval syntax is accepted by the parser, |
| Previous Message | Tom Lane | 2005-03-23 22:13:40 | Re: BUG #1552: massive performance hit between 7.4 and 8.0.1 |