On Sat, 10 Mar 2007, Chuck McDevitt wrote:

> Ok...
> Just to be clear, the ISO SQL spec says that  INTERVAL '1' DAY is the
> correct way to specify a one-day interval.
> That's why it is surprising that PostgreSQL treats it differently, with
> no error or warning.
> The PostgreSQL syntax INTERVAL '1 DAY' is non-standard.
> Is fixing this on the TODO list?

Yes: Add ISO INTERVAL handling

There's detail there about the nature of support required. Personally, I
think the syntax is awful. I don't understand why intervals are handled so
differently in the spec as compared to other data types. This syntax is
well supported by Oracle and DB2 though. I guess it should be completed in



---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at


Reply via email to