Index: src/test/regress/expected/int8-exp-three-digits-win32.out =================================================================== RCS file: /projects/cvsroot/pgsql-server/src/test/regress/expected/int8-exp-three-digits-win32.out,v retrieving revision 1.1 diff -c -r1.1 int8-exp-three-digits-win32.out *** src/test/regress/expected/int8-exp-three-digits-win32.out 29 Feb 2004 02:41:45 -0000 1.1 --- src/test/regress/expected/int8-exp-three-digits-win32.out 12 Mar 2004 07:16:29 -0000 *************** *** 8,13 **** --- 8,28 ---- INSERT INTO INT8_TBL VALUES('4567890123456789','123'); INSERT INTO INT8_TBL VALUES('4567890123456789','4567890123456789'); INSERT INTO INT8_TBL VALUES('4567890123456789','-4567890123456789'); + -- bad inputs + INSERT INTO INT8_TBL(q1) VALUES (' '); + ERROR: invalid input syntax for type bigint: " " + INSERT INTO INT8_TBL(q1) VALUES ('xxx'); + ERROR: invalid input syntax for type bigint: "xxx" + INSERT INTO INT8_TBL(q1) VALUES ('3908203590239580293850293850329485'); + ERROR: integer out of range + INSERT INTO INT8_TBL(q1) VALUES ('-1204982019841029840928340329840934'); + ERROR: integer out of range + INSERT INTO INT8_TBL(q1) VALUES ('- 123'); + ERROR: invalid input syntax for type bigint: "- 123" + INSERT INTO INT8_TBL(q1) VALUES (' 345 5'); + ERROR: invalid input syntax for type bigint: " 345 5" + INSERT INTO INT8_TBL(q1) VALUES (''); + ERROR: invalid input syntax for type bigint: "" SELECT * FROM INT8_TBL; q1 | q2 ------------------+-------------------