Latest posts from Matt Hudson

Postgres Query Boost: Using ANY Instead of IN

The operator has to be in the top-3 SQL-specific operators that people learn, the close competitors are and . Thus, feels familiar when crafting SQL: you can use it with nested SQL statements, or create your own list. But, it does have limitations — what if you wanted to send a list of unknown length? You can’t really use SQL placeholders without also modifying the SQL statement. What if I told you there was a less ubiquitous operator that offered all of the power and less of the drawback...