Adriaan Joubert <[EMAIL PROTECTED]> writes:
> insert into lint values ('9223372036854775807'::int8);
> works, but
> insert into lint values (9223372036854775807::int8);
> doesn't.
Fixed, and checked on Debian Alpha.
regards, tom lane
---(end of
> This is a portability bug, no question. But I'd expect it to fail
> like that on all Alpha-based platforms. Adriaan, when you say it
> works on Linux, are you talking about Linux/Alpha or some other
> hardware?
No, PC Linux. I run a database on my laptop as well.
Adriaan
---
Thomas Lockhart <[EMAIL PROTECTED]> writes:
> For integers (optional sign and all digits), the code in
> src/backend/parser/scan.l uses strtol() to read the string, then checks
> for failure. If it fails, the number is interpreted as a double float on
> the assumption that if it could hold more di
> For integers (optional sign and all digits), the code in
> src/backend/parser/scan.l uses strtol() to read the string, then checks
> for failure. If it fails, the number is interpreted as a double float on
> the assumption that if it could hold more digits it would succeed!
>
> Anyway, either s
