Hi all I have a problem using a CASE statement in a WHERE clause.
On testing a column which contains a ‘1’, WHERE returns true if I test for 1 (without the quotes), but false if I test for ‘1’ (with quotes). CREATE TABLE test_1 (tran_type TEXT, amount INTEGER, posted BOOL) INSERT INTO test_1 (tran_type, amount, posted) values ('inv', 100.00, '1') SELECT * FROM test_1 WHERE CASE WHEN tran_type = 'inv' THEN posted END = 1 [(‘inv’, 100, 1)] SELECT * FROM test_1 WHERE CASE WHEN tran_type = 'inv' THEN posted END = ‘1’ [] I really need this to work, as my app is cross-platform and cross-database, and PostgreSQL does not accept an integer for a BOOL column. I am using version 3.14.2 on Windows 10. Any suggestions? Thanks Frank Millman _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users