From: Simon Slavin Sent: Sunday, December 04, 2016 8:42 AM To: SQLite mailing list Subject: Re: [sqlite] Problem with CASE in WHERE clause
On 4 Dec 2016, at 8:42am, Simon Slavin slav...@bigfraud.org wrote: > What are we allowed to change ? Are you asking us to find a "SELECT" command > which works both in SQLite and PostgreSQL ? Can we change the table > definition too ? Er, sorry, I was not asking you to change anything. If a column contains a ‘1’, I would expect sqlite3 to return true when testing for ‘1’, but in my example it returns false. If this is a bug, then I am happy to wait for a fix. If it is just the way sqlite3 works, a bit of an explanation would help, as that could assist me in finding a workaround. Frank _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users