Re: interesting difference for queries...

On Wed, 2002-12-04 at 11:21, Mario Weilguni wrote:
> I noticed an interesting difference in query behaviour:
>
> cms=# CREATE TABLE foo(bar int);
> CREATE
> cms=# SELECT * from foo where bar=1.7;

This is a numeric to integer coercion, which rounds

rbt=# select 1.7::int;
int4
------
2
(1 row)

> bar
> -----
> (0 rows)
>
> cms=# SELECT * from foo where bar='1.7';
> ERROR: pg_atoi: error in "1.7": can't parse ".7"

This is a text to integer coercion, which doesn't round.

I guess the question is whether or not a numeric -> integer conversion
should 'wedge' numbers into the int, or throw an error.

--
Rod Taylor <rbt(at)rbt(dot)ca>

PGP Key: http://www.rbt.ca/rbtpub.asc