On 14 Mar 2016, at 10:12am, Cezary H. Noweta <chn at poczta.onet.pl> wrote:
> What ``SELECT CAST('100000000000000000000' AS INTEGER);'' should give?
> (String of one and 20 zeroes). Actually, preceding ``SELECT'' gives
> ``7766279631452241920''. Should it be ``9223372036854775807'' (MAXINT64) or
> ``1000000000000000000'' (String of one and 18 zeroes --- maximum length
> INT64)?
I would never write code which depended on the answer to that question. There
are many too many ways for it to fail.
Simon.
