Horton

Re: Bug 1500

Bruno Wolff III <bruno@wolff.to>

View thread
From: Bruno Wolff III <bruno@wolff.to>
To: Steve Crawford <scrawford@pinpointresearch.com>
Cc: Lyubomir Petrov <lpetrov@sysmaster.com>, pgsql-hackers@postgresql.org
Date: 2005-03-26T03:31:17Z
Lists: pgsql-hackers 
On Fri, Mar 25, 2005 at 12:53:53 -0800,
  Steve Crawford <scrawford@pinpointresearch.com> wrote:
> 
> 2) If so, what is the replacement?

You should be able to use EXTRACT, some math to do your own formatting.
For common operations you can define SQL functions to do what you want.
Having to_char(interval) may be more convenient (if it does what you
want), but you can get by without it.