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

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pedro Gimeno <pgsql-004(at)personal(dot)formauri(dot)es>, rschaaf(at)commoninf(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Re: BUG #12885: The result of casting a double to an integer depends on the database version
Date: 2015-03-26 02:12:16
Message-ID: 87h9t84ig5.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

>>>>> "Michael" == Michael Paquier <michael(dot)paquier(at)gmail(dot)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)

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2015-03-26 02:15:59 Re: Re: BUG #12885: The result of casting a double to an integer depends on the database version
Previous Message Tom Lane 2015-03-26 02:07:53 Re: Re: BUG #12885: The result of casting a double to an integer depends on the database version