Re: Re: [BUGS] Return value error of‘to_timestamp’

Поиск
Список
Период
Сортировка
От Aleksander Alekseev
Тема Re: Re: [BUGS] Return value error of‘to_timestamp’
Дата
Msg-id 20160804180309.28bd486a@fujitsu
обсуждение исходный текст
Ответ на Re: [BUGS] Return value error of‘to_timestamp’  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: [BUGS] Re: [BUGS] Return value error of‘to_timestamp’
Список pgsql-bugs
>> postgres=# select to_timestamp('1990-1-1 11:11:11.123456789',
>> 'YYYY-MM-DD HH24:MI:SS.US'); to_timestamp
>> -------------------------------
>>  1990-01-01 11:13:14.456789+08
>> (1 row)
>> postgres=#

> ​Working as designed...​

Maybe it means that current design is poor. However since this behavior
is documented there are users who might depend on it. So I doubt it
will be changed any time soon.

Though I wonder maybe we should consider introducing a new set of
time-related procedures with different behavior (to_timestamp_strict?),
that would be more obvious to users.

--
Best regards,
Aleksander Alekseev



В списке pgsql-bugs по дате отправления:

Предыдущее
От: huang
Дата:
Сообщение: About hash index question
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: [BUGS] Re: [BUGS] Return value error of‘to_timestamp’