Roy Badami wrote: > > Tom> No, it shouldn't; read the SQL spec. AFAICS the syntax > Tom> select interval '1' month is perfectly spec-compliant. The > Tom> variant select interval '1 month' is *not* per-spec, it is a > Tom> Postgres-ism. > > That is my understanding, though I don't have a copy of the spec (my > reference is Date & Darwen's "A guide to the SQL standard")
We have links to the spec in the developer's FAQ. > However, it may be better if the PostgreSQL parser rejected the > syntax. The current behaviour would seem to be a smoking gun for > people porting ANSI-compliant SQL applications (assuming such things > exist :) to PostgreSQL. So, we have a few major problems with intervals. Let me think a little and I will summarize. -- 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
