Re: to_date_valid()

Поиск
Список
Период
Сортировка
Искать
От
Artur Zakirov
Тема
Re: to_date_valid()
Дата
Msg-id
95738e12-6ed6-daf5-9dcf-6336072e6b15@postgrespro.ru
Ответ на
Re: to_date_valid() (Andreas 'ads' Scherbaum)
Список
Дерево обсуждения
to_date_valid() Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
Re: to_date_valid() Amit Kapila <amit.kapila16@gmail.com>
Re: to_date_valid() Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
Re: to_date_valid() Euler Taveira <euler@timbira.com.br>
Re: to_date_valid() Jaime Casanova <jaime.casanova@2ndquadrant.com>
Re: to_date_valid() Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
Re: to_date_valid() Andreas Karlsson <andreas@proxel.se>
Re: to_date_valid() Pavel Stehule <pavel.stehule@gmail.com>
Re: to_date_valid() Andreas Karlsson <andreas@proxel.se>
Re: to_date_valid() Albe Laurenz <laurenz.albe@wien.gv.at>
Re: to_date_valid() Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: to_date_valid() "Joshua D. Drake" <jd@commandprompt.com>
Re: to_date_valid() Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
Re: to_date_valid() Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: to_date_valid() Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
Re: to_date_valid() Artur Zakirov <a.zakirov@postgrespro.ru>
Re: to_date_valid() Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
Re: to_date_valid() Artur Zakirov <a.zakirov@postgrespro.ru>
Re: to_date_valid() Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
Re: to_date_valid() Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: to_date_valid() Tom Lane <tgl@sss.pgh.pa.us>
Re: to_date_valid() Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
Re: to_date_valid() Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: to_date_valid() Craig Ringer <craig@2ndquadrant.com>
Re: to_date_valid() Pavel Stehule <pavel.stehule@gmail.com>
Re: to_date_valid() Pavel Stehule <pavel.stehule@gmail.com>
Re: to_date_valid() Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
Re: to_date_valid() Pavel Stehule <pavel.stehule@gmail.com>
Re: to_date_valid() Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
Re: to_date_valid() Pavel Stehule <pavel.stehule@gmail.com>
Re: to_date_valid() Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
Re: to_date_valid() "David G. Johnston" <david.g.johnston@gmail.com>
Re: to_date_valid() Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>
Re: to_date_valid() "David G. Johnston" <david.g.johnston@gmail.com>
Re: to_date_valid() Bruce Momjian <bruce@momjian.us>
Re: to_date_valid() Pavel Stehule <pavel.stehule@gmail.com>
Re: to_date_valid() Gavin Flower <GavinFlower@archidevsys.co.nz> 
On 14.08.2016 01:52, Andreas 'ads' Scherbaum wrote:
>
> Attached is a patch to "do the right thing". The verification is in
> "to_date()" now, the extra function is removed. Regression tests are
> updated - two or three of them returned a wrong date before, and still
> passed. They fail now. Documentation is also updated.
>
>
> Regards,
>

Is it right and "true" way to validate date by extra transforming and 
comparison?

Maybe validate date by using ValidateDate(). Attached sample patch.

-- 
Artur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
В списке pgsql-hackers по дате отправления
Предыдущее
От: Mark Kirkwood
Дата:
Следующее
От: Andrew Borodin
Дата:
FAQ