Re: check date validity

Поиск
Список
Период
Сортировка
От Jeff Eckermann
Тема Re: check date validity
Дата
Msg-id 20040116145715.61657.qmail@web20811.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: check date validity  (Harald Fuchs <hf99@protecting.net>)
Ответы Re: check date validity  (Joe Conway <mail@joeconway.com>)
sql to get the column names of a table  (Alexander Antonakakis <motoris@sdf.lonestar.org>)
Список 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 по дате отправления:

Предыдущее
От: "Ivar"
Дата:
Сообщение: Re: Creating GUID
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Returning large select results from stored procedures