Hello, On 2016-03-14 12:03, Clemens Ladisch wrote: > The documentation is quite clear that INTEGERs have 64 bits. So trying > to use integers above 9223372036854775807 is something that is better > not to be done.
How could somebody use integers above 9223372036854775807 if they do not exist? '100000000000000000000' is a TEXT, not INTEGER. I asked about CASTing to INTEGER. Is your opinion that ``SELECT CAST(col AS INTEGER);'' should return (not so) random result set, and receiving any INTEGER should mean that a source string could have trillion or more possible values? -- best regards Cezary H. Noweta