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

^F case-insensitive search for:

  - cte
  - recursive
  - with (in SQL code, not prose)
  - connect (as in Oracle's CONNECT BY)
nothing. Nothing!

SQL deals with hierarchical data just fine. You just have to learn about how (recursive CTEs).



I've recently been learning about Datalog, which is excellent for all the queries that you'd want to do with recursive CTEs, but has the added benefit of making it much easier to factor one's code into discrete units (relations) for reusability.




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

Search: