Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> writes: > Reading through the sql2003 spec, it would appear that the "proper" way > to represent an interval would be: > interval '10' day This is not actually implemented. The bizarre special-purpose syntax the spec requires for datetime literals was something that was on Tom Lockhart's to-do list, but when he got bored and left the project, nobody else picked it up. I'm not entirely certain how much work remains to handle the spec syntax. In the real world, the form we do support is a lot better (can you imagine trying to programmatically insert interval parameter values into a statement using the spec's syntax? Yech.) regards, tom lane
