Hello Team,
While reading your Wiki page: http://wiki.postgresql.org/wiki/CTEReadme
In section, How Recursion Works, item (2), I am wondering if the code
snippet is wrong. Here is the excerpt:
2) Execute recursive query
Replace subdepartment with WorkTable and execute the recursive term
SELECT d.*
FROM
WT AS d
JOIN
subdepartment AS sd
ON d.parent_department = sd.id
It would be nice to see it corrected.
Thanks