Re: Bug 1500

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Cc: Lyubomir Petrov <lpetrov(at)sysmaster(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Bug 1500
Date: 2005-03-26 03:31:17
Message-ID: 20050326033117.GA20688@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Mar 25, 2005 at 12:53:53 -0800,
Steve Crawford <scrawford(at)pinpointresearch(dot)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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2005-03-26 04:10:58 8.0.2beta1 ... look her over ...
Previous Message Alvaro Herrera 2005-03-26 03:20:39 Re: HeapTupleSatisfiesUpdate missing a bet?