Karel Zak <[EMAIL PROTECTED]> writes: > Hmm, if we want to support conversion like: > '43 hours 20 minutes' --> 'MI min' > how we should work with calendar INTERVAL units? For example 'month'? > '1 month 1 day' --> 'D days' > I think answer should be error message: "missing calendar unit 'month' > in output format"
Surely not. to_char for timestamps doesn't require that you output every field of the value, and it shouldn't require that for intervals either. regression=# select to_char(now(), 'MI "min"'); to_char --------- 58 min (1 row) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])