Re: Re: BUG #12885: The result of casting a double to an integer depends on the database version

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Re: BUG #12885: The result of casting a double to an integer depends on the database version
Дата
Msg-id CAB7nPqTtEJB08PEVj48SL4fFYMTaAxVX3CPE77SCpHYoZ3763Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Re: BUG #12885: The result of casting a double to an integer depends on the database version  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Ответы Re: Re: BUG #12885: The result of casting a double to an integer depends on the database version  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-bugs
On Thu, Mar 26, 2015 at 11:12 AM, Andrew Gierth wrote:
>>>>>> "Michael" == Michael Paquier writes:
>
>  Michael> Indeed...
>  Michael> =# select column1 AS double_value, cast(column1 AS INT) AS
>  Michael> int_value
>
> The complication for numeric is that there's also the case of round(x,n)
> and casting to numeric(m,n) to consider.

OK, thanks for the reminder... I forgot this case.
--
Michael

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

Предыдущее
От: Andrew Gierth
Дата:
Сообщение: Re: Re: BUG #12885: The result of casting a double to an integer depends on the database version
Следующее
От: Pedro Gimeno
Дата:
Сообщение: Re: Re: BUG #12885: The result of casting a double to an integer depends on the database version