Re: Bug 1500

On Sat, Mar 26, 2005 at 02:04:14PM -0800, Josh Berkus wrote:

> SELECT to_char( INTERVAL '43 hours 20 minutes', 'MI' ) || ' min';
> 2600 min

Hmm, what if you wanted more than one literal string?  Say "1 mon 3
days" ... your concatenation idea wouldn't work.  ISTM the format string
should allow unconverted literals, so you would use

SELECT to_char( INTERVAL '43 hours 20 minutes', 'MI min' );

-- 
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Cuando no hay humildad las personas se degradan" (A. Christie)