Bruce> I guess my point is that we should allow:
Bruce> select interval '1' day '1' hour
Bruce> as SQL standard and equavalent to:
Ah, I think you're misunderstanding what the SQL standard interval
literal syntax looks like.
It would be
INTERVAL '1 1' DAY TO HOUR
Essentially the full syntax for a day-time interval is
INTERVAL '1 2:03:04' DAY TO SECOND
and the full syntax of a year-month interval is
INTERVA: '1-2' YEAR TO MONTH
but if you use a more restricted interval type you omit the fields
that aren't present in your interval type.