On Wed, 2002-12-04 at 12:22, Tom Lane wrote:
> Rod Taylor <rbt@rbt.ca> 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 <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.asc