Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: BUG #12885: The result of casting a double to an integer depends on the database version - Mailing list pgsql-bugs

From Andrew Gierth
Subject Re: Re: BUG #12885: The result of casting a double to an integer depends on the database version
Date
Msg-id 87h9t84ig5.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: Re: BUG #12885: The result of casting a double to an integer depends on the database version  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: Re: BUG #12885: The result of casting a double to an integer depends on the database version  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-bugs
Tree view 
>>>>> "Michael" == Michael Paquier <michael.paquier@gmail.com> 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.

--
Andrew (irc:RhodiumToad)

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: BUG #12885: The result of casting a double to an integer depends on the database version
Next
From: Michael Paquier
Date:
Subject: Re: Re: BUG #12885: The result of casting a double to an integer depends on the database version