INT8 / float casting question

From: Filip Rembiałkowski <filip(dot)rembialkowski(at)gmail(dot)com>
To: Community PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: INT8 / float casting question
Date: 2014-10-31 14:58:06
Message-ID: CAP_rwwksWXsxon-fbG5itzXPjCHAY9cXoKH139jVV1J3J5w+8A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Thanks
Filip

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Campbell, Lance 2014-10-31 14:59:48 best strategy for searching large text fields
Previous Message Tim Dudgeon 2014-10-30 19:22:07 Re: querying within json