interesting difference for queries...

From: "Mario Weilguni" <mario(dot)weilguni(at)icomedias(dot)com>
To: "Postgresql Mailinglist (E-Mail)" <pgsql-hackers(at)postgresql(dot)org>
Subject: interesting difference for queries...
Date: 2002-12-04 16:21:50
Message-ID: 4D618F6493CE064A844A5D496733D66703921E@freedom.icomedias.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-12-04 16:28:12 Re: PQnotifies() in 7.3 broken?
Previous Message Rod Taylor 2002-12-04 16:18:55 Re: [ADMIN] how to alter sequence.