Re: A creepy story about dates. How to prevent it? - Mailing list pgsql-general

From Jonathan Bartlett
Subject Re: A creepy story about dates. How to prevent it?
Date
Msg-id Pine.GSU.4.44.0306190639160.16766-100000@eskimo.com
Whole thread Raw
In response to Re: A creepy story about dates. How to prevent it?  (Ron Johnson <ron.l.johnson@cox.net>)
Responses Re: A creepy story about dates. How to prevent it?
List pgsql-general
The problem is that you can't do the check on the _field_ since it has
already been converted to a date.

Jon

On 19 Jun 2003, Ron Johnson wrote:

> On Thu, 2003-06-19 at 05:35, Bruno Wolff III wrote:
> > On Thu, Jun 19, 2003 at 02:43:12 -0500,
> >   Ron Johnson <ron.l.johnson@cox.net> wrote:
> > >
> > > OTOH, Andrew Snow's method (alway use ANSI standard YYYY-MM-DD)
> > > is guaranteed to work.  Have your app convert to that format before
> > > inserting, and then PostgreSQL is guaranteed to puke if there's
> > > a problem.
> >
> > No it isn't. In 7.4:
> > area=> select '2003-20-02'::date;
> >     date
> > ------------
> >  2003-02-20
> > (1 row)
>
> Whoa...
>
> It shouldn't be difficult, though, to create a function to validate
> dates, and have it be an implicit CHECK on date fields.  Should it?
>
> --
> +-----------------------------------------------------------+
> | Ron Johnson, Jr.     Home: ron.l.johnson@cox.net          |
> | Jefferson, LA  USA   http://members.cox.net/ron.l.johnson |
> |                                                           |
> | "Oh, great altar of passive entertainment, bestow upon me |
> |  thy discordant images at such speed as to render linear  |
> |  thought impossible" (Calvin, regarding TV)               |
> +-----------------------------------------------------------
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>


pgsql-general by date:

Previous
From: "Carlos Oliva"
Date:
Subject: FW: Allowing user to connect to a database?
Next
From: "Peter Haworth"
Date:
Subject: Re: A creepy story about dates. How to prevent it?