On Wed, 2002-12-04 at 12:22, Tom Lane wrote: > Rod Taylor <[EMAIL PROTECTED]> writes: > >> cms=# CREATE TABLE foo(bar int); > >> CREATE > >> cms=# SELECT * from foo where bar=1.7; > > > This is a numeric to integer coercion, which rounds > > No, it's an integer to numeric promotion (the var is promoted, not the > constant). Obviously the '=' can never return true in this case.
Ahh, sorry. I see I changed the query slightly when doing the verbose explain. -- Rod Taylor <[EMAIL PROTECTED]> PGP Key: http://www.rbt.ca/rbtpub.asc
signature.asc
Description: This is a digitally signed message part
