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 AANLkTinrREOZ=ECnAuAT3RtqFoG3q+4quEDquYiCLQvb@mail.gmail.com
Whole thread Raw
In response to Integer input functions for date and timestamp  (Brendan Jurd <direvus@gmail.com>)
List pgsql-hackers
On Fri, Oct 22, 2010 at 2:45 PM, Brendan Jurd <direvus@gmail.com> wrote:
> date(year int, month int, day int) returns date
> datetime(year int, month int, day int, hour int, minute int, second
> int) returns timestamp
>
> Without these functions (or some variation), a user wishing to
> construct a date from integers can only assemble the date into a
> string and then put that string through postgres' datetime parser,
> which is totally perverse.
>
> Is there any interest in adding this to core, or failing that,
> contrib?  If so I'd be happy to provide a patch including the
> functions themselves and some attendant documentation.

I think that would be useful.

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


pgsql-hackers by date:

Previous
From: fazool mein
Date:
Subject: xlog.c: WALInsertLock vs. WALWriteLock
Next
From: Brendan Jurd
Date:
Subject: Re: Integer input functions for date and timestamp