Home > mailing lists

INT8 / float casting question - Mailing list pgsql-sql

From	Filip Rembiałkowski
Subject	INT8 / float casting question
Date	October 31, 2014 17:58:38
Msg-id	CAP_rwwksWXsxon-fbG5itzXPjCHAY9cXoKH139jVV1J3J5w+8A@mail.gmail.com Whole thread Raw
Responses	Re: INT8 / float casting question Re: INT8 / float casting question Re: INT8 / float casting question
List	pgsql-sql

Tree view

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

pgsql-sql by date:

From: Tim Dudgeon
Date: 30 October 2014, 22:22:21
Subject: Re: querying within json

From: "Campbell, Lance"
Date: 31 October 2014, 18:00:08
Subject: best strategy for searching large text fields

INT8 / float casting question - Mailing list pgsql-sql

Previous

Next