From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | BigO DBA <bigodba(at)gmail(dot)com> |
Cc: | pgsql-www(at)postgresql(dot)org |
Subject: | Re: Page About CTE's |
Date: | 2010-10-20 13:55:30 |
Message-ID: | AANLkTikxX8rK6DbS+RWo-_LUpiz9D3S1mOE10HwT=QMP@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-www |
On Tue, Oct 19, 2010 at 7:24 PM, BigO DBA <bigodba(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2010-10-20 14:43:53 | New books on PostgreSQL |
Previous Message | BigO DBA | 2010-10-19 23:24:32 | Page About CTE's |