sweet-liberty icon indicating copy to clipboard operation
sweet-liberty copied to clipboard

`query/create-h-sql-where-vector` incompatible with PSQL

Open owengalenjones opened this issue 9 years ago • 2 comments

Calling str on something like {:id 4} will result in:

com.rjmetrics.sweet-liberty.db {"raw-query":["SELECT email, id FROM users WHERE id = ?","1"]}

Which throws an error in PSQL, it's not as forgiving as MySQL:

ERROR:  operator does not exist: integer = character varying at character 38
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

owengalenjones avatar Sep 07 '15 02:09 owengalenjones