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

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 (view raw or flat)
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

pgsql-hackers by date

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

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