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. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])