5 ms·
with has completely changed my usage of PostgreSQL. I am a newbie and being able to split queries into logical small steps with this has made SQL much more fun.
by anc84 11y ago
with has completely changed my usage of PostgreSQL. I am a newbie and being able to split queries into logical small steps with this has made SQL much more fun.
- ape4 11y agoBut don't you still get big long queries. Or can you make separate statements?
- anc84 11y agoNot sure what you mean?
- greggyb 11y agoA long query written with CTEs is eminently more readable than the logically equivalent query written with nested sub-queries. Just like a pipe operator makes long strings of function calls more readable than the semantically identical nested function calls.