In PostgreSQL, you can't use IN to check whether a value is inside an array, you have to use the following PostgreSQL-specific syntax: where ...
error-42601-syntax-error-at-or-near-postgresql
3925e8d270
org.postgresql.util.psqlexception error syntax error at or near, org.postgresql.util.psqlexception error syntax error at or near $1, caused by org.postgresql.util.psqlexception error syntax error at or near user, error syntax error at or near into postgresql, postgresql error syntax error at or near, org.postgresql.util.psqlexception error syntax error at or near $2, postgresql error syntax error at or near merge, org.postgresql.util.psqlexception error syntax error at or near cross, error syntax error at or near select postgresql, org.postgresql.util.psqlexception error syntax error at or near limit, error syntax error at or near postgresql, error syntax error at or near postgresql copy, error syntax error at or near foreign postgresql, error syntax error at or near if postgresql, error syntax error at or near constraint postgresql, error syntax error at or near set postgresql, error syntax error at or near integer postgresql, error syntax error at or near procedure postgresql
Comments