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

Re: to_date gives odd results

From: "Josh Tolley" <eggyknap(at)gmail(dot)com>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
Cc: "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: to_date gives odd results
Date: 2007-08-31 13:35:28
Message-ID: e7e0a2570708310635x5d2b8920h6e1c8bc30b3ab6ae@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On 8/31/07, Alvaro Herrera <alvherre(at)commandprompt(dot)com> wrote:
> Josh Tolley escribió:
> > > On Thursday 30 August 2007 21:15, Tom Lane wrote:
> > > > to_date and friends are fairly awful in terms of not throwing errors
> > > > when the input doesn't really match the format.  I think what you
> > > > shoulda got here is a bad-input error.  However, somebody's going to
> > > > have to do a major rewrite of formatting.c to make it much better...
> >
> > Any votes for making that formatting.c rewrite a TODO item?
>
> Well, there is already a to_char patch scheduled for 8.4.  If you want
> to improve the to_date code, you are invited to do so -- no need to have
> a TODO item about it.

I figured as much.

> If what you expect is that having a TODO item will mean that somebody
> else will start working on it, I think you'll be disappointed :-)

I realize this chance is slim. The likelihood that I could get to it
and make something useful of it seemed even more slim :)

> (OTOH maybe we should add it and put the % mark in it.)

- Josh

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-08-31 14:00:17
Subject: Re: BUG #3590: Error while in Plpgsql :
Previous:From: Alvaro HerreraDate: 2007-08-31 13:33:04
Subject: Re: to_date gives odd results

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