Skip site navigation (1) Skip section navigation (2)

Re: Page About CTE's

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 (view raw or flat)
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

In response to

pgsql-www by date

Next:From: Simon RiggsDate: 2010-10-20 14:43:53
Subject: New books on PostgreSQL
Previous:From: BigO DBADate: 2010-10-19 23:24:32
Subject: Page About CTE's

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group