Re: [sqlite] SQLite version 3 design question: '500'=500?

[Kevin Van Vechten]

Another interesting data point, note the difference between ' and ".

Welcome to psql 7.4, the PostgreSQL interactive terminal.
kevin=# select '500'=500;
 ?column?
----------
 t
(1 row)
kevin=# select "500"=500;
ERROR:  column "500" does not exist
On May 12, 2004, at 5:19 PM, D. Richard Hipp wrote:

Note that in other SQL engines, it is an error to compare
a string to an integer (I think - somebody please correct
me if I am wrong) so we cannot get any guidance there.
Your thoughts?


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]