Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

No questions/examples featuring recursive CTE's? They tend to come up in anything involving queries over trees or graphs. They're also a relatively new feature where having some examples to show how they work may be quite helpful.


Took me some time to wrap my head around writing a recursive query. Also had to study the docs a while to get "merge into" to work right, for doing combined insert/update.


One of the first tasks I give associate DBAs is writing a recursive CTE to get a blocking chain. It’s an interesting and useful exercise.




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

Search: