brianc/node-sql

column.in(emptyArray) results with SQL syntax error (postgres)

Closed this issue · 2 comments

This will generate

WHERE column IN ()

which seems to be a syntax error, at least in postgres

Perhaps the IN binary clause should have a special case where its replaced with a falsy value if the right side is an empty array?

Edit: Just to clarify, I'm trying to figure out if this behavior is intended and if not, what would be the best way to go about fixing it (before submitting pull requests :D)

I think this can be closed now.

👍