Re: Which casts should be implicit

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Which casts should be implicit
Дата
Msg-id GNELIHDDFBOCMGBFGEFOOEFMCDAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответ на Which casts should be implicit  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: Which casts should be implicit  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Список pgsql-hackers
> date -> timestamp[tz]:  I'm suspicious of this one, but it's hard to
> explain.  The definition to fill in the time component with zeros is
> reasonable, but it's not the same thing as casting integers to floats
> because dates really represent a time span of 24 hours and timestamps an
> indivisible point in time.  I suggest making this non-implicit, for
> conformance with SQL and for general consistency between the date/time
> types.

Althought I'm sure there's _loads_ of people using this conversion,
including me in various random places in the codebase.

Chris



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

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: Oracle Decode Function
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: Which casts should be implicit