Alvaro,
> 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' );
Hmmm, good point.
Question: how does to_char tell the difference between a code ("MI") and a
code which is also part of a word? ("MIN").
--Josh
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
