Re: interval behaviour

Scott Marlowe <smarlowe(at)g2switchworks(dot)com> 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