| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Mario Weilguni <mario(dot)weilguni(at)icomedias(dot)com>, Postgresql Mailinglist <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: interesting difference for queries... |
| Date: | 2002-12-04 17:55:18 |
| Message-ID: | 1039024518.35854.66.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, 2002-12-04 at 12:22, Tom Lane wrote:
> Rod Taylor <rbt(at)rbt(dot)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(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-12-04 17:57:05 | Re: [GENERAL] PostgreSQL Global Development Group Announces |
| Previous Message | Oliver Elphick | 2002-12-04 17:54:07 | Re: [HACKERS] how to alter sequence. |