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

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
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:15:59
Message-ID: CAB7nPqTtEJB08PEVj48SL4fFYMTaAxVX3CPE77SCpHYoZ3763Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message hu_didi 2015-03-26 04:03:21 BUG #12903: cannot start, locale problem
Previous Message Andrew Gierth 2015-03-26 02:12:16 Re: Re: BUG #12885: The result of casting a double to an integer depends on the database version