Horton

Re: Bug 1500

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Karel Zak <zakkr@zf.jcu.cz>
Cc: josh@agliodbs.com, Alvaro Herrera <alvherre@dcc.uchile.cl>, List pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2005-03-27T15:58:28Z
Lists: pgsql-hackers 
Karel Zak <zakkr@zf.jcu.cz> 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