Page About CTE's - Mailing list pgsql-www

From BigO DBA
Subject Page About CTE's
Date
Msg-id AANLkTin3qixwWxxJTbzQt3zpuQdn5LX0b9JrMGZU8=g4@mail.gmail.com
Whole thread Raw
Responses Re: Page About CTE's
List pgsql-www
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

pgsql-www by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: web site change is broken
Next
From: Robert Haas
Date:
Subject: Re: Page About CTE's