SQLite 3.8.3 adds support for CTE. I tried some sample CTEs on this page and they work fine. However, after reading the documentation and trying to adjust some examples, I can’t Create a simple tes
Tag: Recursive
Looking for the build forest (with recursive, postgreSQL 9.5)
I have a table of identities (ie aliases) for any number of people. Each row has a previous name and a new name. In production, there are approximately 1M rows. For example:
id, old, new
—