Re: Integer input functions for date and timestamp - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Integer input functions for date and timestamp
Date
Msg-id AANLkTi=6HfxHsTBr0fz0M-uh_xG0Jd1B2iY=mwNrw7eY@mail.gmail.com
Whole thread Raw
In response to Re: Integer input functions for date and timestamp  (Brendan Jurd <direvus@gmail.com>)
Responses Re: Integer input functions for date and timestamp
Re: Integer input functions for date and timestamp
List pgsql-hackers
On Fri, Oct 22, 2010 at 3:20 PM, Brendan Jurd <direvus@gmail.com> wrote:
> On 23 October 2010 06:15, Josh Berkus <josh@agliodbs.com> wrote:
>> a) you'd need to rename these.
>
> I'm open to that.  What names would you propose?
>
>> b) we'd also want the inverse of these, which would be extremely useful.
>
> Not a problem.

Ooh, I like it.  A related personal pet peeve of mine: AFAIK the
easiest way to convert from an integer number of seconds to an
interval representing that many seconds is:

(the_int || ' s')::interval

I guess we don't want to get too carried away with this, but has
anyone else gotten annoyed by this?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Extensions, this time with a patch
Next
From: Alvaro Herrera
Date:
Subject: Re: Extensions, this time with a patch