not= query is throwing a PSQLException

[NeilMenne]

The exception is a syntax error.

I am doing something like:

(select my_table (where (not= :boolcolumn false)))

This throws an exception stating that there's a syntax error at or near $1 which is what should be the false.

As a further attempt at digging into the problem, I tried:

(exec-raw ["SELECT * FROM my_table WHERE boolcolumn IS NOT ?" [false]] :results)

This returns the same exception.

I am using version 9.3.5 of PostgresSQL and the following from my project file:

[korma "0.4.0"]
[org.postgresql/postgresql "9.4-1201-jdbc4"]

[immoh]

Seems to be a bug, not= is not handled correctly. You can use

(where (not (= :boolcolumn false)))

which should work ok.

[NeilMenne]

Yeah, I can confirm that this works.

Thanks!