Recursive common table expressions are indeed very powerful! You can even solve ... | Hacker News

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

login

ThePhysicist on July 21, 2015 | parent | context | favorite | on: Woah that is some wild postgresql

Recursive common table expressions are indeed very powerful! You can even solve the eight queens problem in them:

http://www.andreas-dewes.de/en/2015/queens-of-the-data-age-a...

As others have pointed out there is a really nice section on CTEs in the SQLite documenation as well:

https://www.sqlite.org/lang_with.html

mjn on July 21, 2015 [–]

With these features that have been added to SQL over the past decades, you could probably at this point implement Datalog in it, or a Datalog-to-SQL translator. Might be an interesting experiment.

Join us for AI Startup School this June 16-17 in San Francisco!
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact