Обсуждение: Page About CTE's

Поиск
Список
Период
Сортировка

Page About CTE's

От
BigO DBA
Дата:
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

Re: Page About CTE's

От
Robert Haas
Дата:
On Tue, Oct 19, 2010 at 7:24 PM, BigO DBA <bigodba@gmail.com> wrote:
> 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.

Yes, I think you're right.  Feel free to fix it.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company