I changed the query to use EXISTS because if there’s more than one location associated with a POST, there’d be duplicate POST records that’d require a DISTINCT or GROUP BY clause to get rid of… The non-sargable This will perform the worst of the possible solutions: SELECT p.* FROM POSTS p WHERE EXISTS(SELECT NULL FROM … Read more
Brace expansion doesn’t work, but *, ? and [] do. If you set shopt -s extglob then you can also use extended pattern matching: ?() – zero or one occurrences of pattern *() – zero or more occurrences of pattern +() – one or more occurrences of pattern @() – one occurrence of pattern !() … Read more
You must use: case item when MyClass … I had the same problem: How to catch Errno::ECONNRESET class in “case when”?