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

[Doug Currie]

Results from Firebird 1.5 (thanks for the syntax, Andrew)...

SQL> select '500' = 500;
Statement failed, SQLCODE = -104

Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, char 14
-=
SQL> select 500 = '500';
Statement failed, SQLCODE = -104

Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, char 12
-=
SQL> select 500 = 500;
Statement failed, SQLCODE = -104

Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, char 12
-=
SQL> select  case when 5 = '5' then 1 else 0 end as bool from t1;

        BOOL
============

           1

SQL> select  case when '5' = 5 then 1 else 0 end as bool from t1;

        BOOL
============

           1

e


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