Message-ID: <5453AAEC.8050505@aklaver.com>
Date: Fri, 31 Oct 2014 08:29:48 -0700
From: Adrian Klaver <adrian.klaver@aklaver.com>
User-Agent: Mozilla/5.0 (X11; Linux i686;
 rv:31.0) Gecko/20100101 Thunderbird/31.2.0
MIME-Version: 1.0
To: =?UTF-8?B?RmlsaXAgUmVtYmlhxYJrb3dza2k=?= <filip.rembialkowski@gmail.com>,
 Community PostgreSQL <pgsql-sql@postgresql.org>
Subject: Re: INT8 / float casting question
References: 
 <CAP_rwwksWXsxon-fbG5itzXPjCHAY9cXoKH139jVV1J3J5w+8A@mail.gmail.com>
In-Reply-To: 
 <CAP_rwwksWXsxon-fbG5itzXPjCHAY9cXoKH139jVV1J3J5w+8A@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On 10/31/2014 07:58 AM, Filip Rembiałkowski wrote:
> psql.bin (9.3.4, server 9.3.5)
> Type "help" for help.
>
> dev=# select (2^63-1)::INT8;
> ERROR:  bigint out of range
>

> Does it HAVE to be so?
>
>
> http://en.wikipedia.org/wiki/9223372036854775807

It seems to be not a problem with the number but the exponentiation and 
casting:

test=# create table bigint_test (int_fld int8);
CREATE TABLE
test=# insert into bigint_test values (9223372036854775807);
INSERT 0 1
test=# select * from bigint_test ;
        int_fld
---------------------
  9223372036854775807

test=# select 2^63-1;
        ?column?
----------------------
  9.22337203685478e+18
(1 row)

test=# select (2^63-1)::int8;
ERROR:  bigint out of range


>
>
>
> Thanks
> Filip
>
>


-- 
Adrian Klaver
adrian.klaver@aklaver.com


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql