Skip site navigation (1) Skip section navigation (2)

Re: Bug 1500

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Bug 1500
Date: 2005-03-26 23:13:02
Message-ID: 20050326231302.GA15739@dcc.uchile.cl (view raw or flat)
Thread:
Lists: pgsql-hackers
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[(at)]dcc(dot)uchile(dot)cl>)
"Cuando no hay humildad las personas se degradan" (A. Christie)

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2005-03-26 23:39:42
Subject: Re: Bug 1500
Previous:From: Josh BerkusDate: 2005-03-26 22:04:14
Subject: Re: Bug 1500

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group