I noticed an interesting difference in query behaviour: cms=# CREATE TABLE foo(bar int); CREATE cms=# SELECT * from foo where bar=1.7; bar ----- (0 rows)
cms=# SELECT * from foo where bar='1.7'; ERROR: pg_atoi: error in "1.7": can't parse ".7" Is this the same problem as index usage with/without quotes? However, one would expect the same output from both queries, either the error message, or better the 0 rows result. Regards Mario Weilguni ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly