Re: check date validity - Mailing list pgsql-general

From Jeff Eckermann
Subject Re: check date validity
Date
Msg-id 20040116145715.61657.qmail@web20811.mail.yahoo.com
Whole thread Raw
In response to Re: check date validity  (Harald Fuchs <hf99@protecting.net>)
Responses Re: check date validity  (Joe Conway <mail@joeconway.com>)
sql to get the column names of a table  (Alexander Antonakakis <motoris@sdf.lonestar.org>)
List pgsql-general
--- Harald Fuchs <hf99@protecting.net> wrote:
> In article
> <20040116054046.E4E751C173283@smtp.vip.163.com>,
> "LitelWang" <wlxyk@vip.163.com> writes:
>
> > I need this function :
> > CheckDate('2002-02-29') return false
> > CheckDate('2002-02-28') return true
>
> Why would you want to do that?  Just try to insert
> '2002-02-29' into
> your DATE column, and PostgreSQL will complain.

That will cause the whole transaction to abort, which
is probably not what is wanted.

I don't know any way around this in Postgres.  Best to
check this in application code.

__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus

pgsql-general by date:

Previous
From: "Ivar"
Date:
Subject: Re: Creating GUID
Next
From: Bill Moran
Date:
Subject: Re: Returning large select results from stored procedures