8 ms·
FWIW I just tested a somewhat complex query using HAVING vs a sub-select as you indicated and Postgres generated the same query plan (and naturally, results) fo
by syntheticcdo 4y ago
FWIW I just tested a somewhat complex query using HAVING vs a sub-select as you indicated and Postgres generated the same query plan (and naturally, results) for both.
- djbusby 4y agoA DB wizard I used to work for showed me HAVING after looking at this nasty sub-sub select I did, with some app-layer-loop after. Caesar if you see this thanks for being a great mentor.