Re: [HACKERS] to_char(interval) issues

2005-05-07 Thread Josh Berkus
Bruce, * Prevent to_char() on interval from returning meaningless values * Allow to_char() on interval values to accumulate the highest unit   requested Sounds like it would cover my use cases. Others? -- Josh Berkus Aglio Database Solutions San Francisco ---(end

[HACKERS] to_char(interval) issues

2005-05-06 Thread Bruce Momjian
Based on this discussion I have added these TODO items: * Prevent to_char() on interval from returning meaningless values For example, to_char('1 month', 'mon') is meaningless. Basically, most date-related parameters to to_char() are meaningless for intervals because interval is not