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 (<[EMAIL PROTECTED]>) "Cuando no hay humildad las personas se degradan" (A. Christie) ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
