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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
