Horton

Re: Bug 1500

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

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alvaro Herrera <alvherre@dcc.uchile.cl>
Cc: Josh Berkus <josh@agliodbs.com>, pgsql-hackers@postgresql.org
Date: 2005-03-26T23:39:42Z
Lists: pgsql-hackers 
Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> ...  ISTM the format string
> should allow unconverted literals, so you would use

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

... which to_char can do already, IIRC.  The rewrite should define a new
set of format substitution codes, but not otherwise change the behavior
of to_char.

			regards, tom lane