Hacker News new | past | comments | ask | show | jobs | submit login

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.



But don't you still get big long queries. Or can you make separate statements?


A 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.


Not sure what you mean?




Consider applying for YC's Spring batch! Applications are open till Feb 11.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: