Re: to_date_valid()
| От | Craig Ringer |
|---|---|
| Тема | Re: to_date_valid() |
| Дата | |
| Msg-id | CAMsr+YHkfZ3KtRwrX+cYOLMXgUzFLTyfNnuNMB7KjOLhi6Mrig@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: to_date_valid() (Euler Taveira <euler@timbira.com.br>) |
| Ответы |
Re: to_date_valid()
|
| Список | pgsql-hackers |
On 3 July 2016 at 09:32, Euler Taveira <euler@timbira.com.br> wrote:
-- On 02-07-2016 22:04, Andreas 'ads' Scherbaum wrote:
> The attached patch adds a new function "to_date_valid()" which will
> validate the date and return an error if the input and output date do
> not match. Tests included, documentation update as well.
>
Why don't you add a third parameter (say, validate = true | false)
instead of creating another function? The new parameter could default to
false to not break compatibility.
because
SELECT to_date('blah', 'pattern', true)
is less clear to read than
SELECT to_date_valid('blah', 'pattern')
and offers no advantage. It's likely faster to use a separate function too.
В списке pgsql-hackers по дате отправления: