Karel Zak <zakkr(at)zf(dot)jcu(dot)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
regression=# select to_char(now(), 'MI "min"');
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2005-03-27 17:44:41|
|Subject: Making oidvector and int2vector variable-length|
|Previous:||From: Karel Zak||Date: 2005-03-27 11:03:33|
|Subject: Re: Bug 1500|