News for hackers. Stuff that matters.
Re:SQL Tips and Tricks by paperplatter on Wednesday September 25, 2024 @12:19PM (#41649051)
I get how this isn't good. But how else would you handle multi-field filtering, keep all the ANDs and use (product_id = $1 OR $1 IS NULL) so the unset filters are no-op? That's ok as long as the query planner is smart enough.

There are no comments on this comment yet.