Re: [BUGS] bigint and int8 bug on postgres version 7.2 database.

2002-04-18 Thread Tom Lane
[EMAIL PROTECTED] writes: > [ strange behavior ] What do you get from a simple select 123456789012345::int8; What platform are you on, what compiler, etc? It sounds like configure decided that you didn't have any int8 support available ... regards, tom lane --

[BUGS] bigint and int8 bug on postgres version 7.2 database.

2002-04-18 Thread Vicky . Pan
Dear Bug Killer, I created table with int8/bigint columns in postgres version 7.2 database. 1.When I inserted data with an integer less than or equal to 10 digit, it ok. But when I inserted data with an integer more than 10 digit I got following error massage: ERROR: Floating point