2 ms·
While it's hard to deny the results, the human readability of the final solution leaves a lot to be desired, especially for SQL casuals.
by bentcorner 13y ago
While it's hard to deny the results, the human readability of the final solution leaves a lot to be desired, especially for SQL casuals.
- calinet6 13y agoAt least with Postgres (and MySQL to some degree, but Postgres is probably a better launching point), you could hack the query optimizer to handle situations like this if you really wanted to. I like to think this is how Postgres would like you to approach the problem, instead of creating a less comprehensible query.