Re: Learning about WITH RECURSIVE - Mailing list pgsql-sql

From Richard Broersma
Subject Re: Learning about WITH RECURSIVE
Date
Msg-id 396486430911041417o40cf1939k6ff703ca704a3e14@mail.gmail.com
Whole thread Raw
In response to Re: Learning about WITH RECURSIVE  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
On Wed, Nov 4, 2009 at 2:11 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Richard Broersma <richard.broersma@gmail.com> writes:
>> Can anyone one explain why a "WITH RECURSIVE" query has the same
>> results regardless whether UNION or UNION ALL is specified?
>
> Well, if the rows are all different anyway, UNION isn't going to
> eliminate any ...

Okay thanks.  I see that I need to spend more time with the on-line docs.

-- 
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Learning about WITH RECURSIVE
Next
From: Richard Broersma
Date:
Subject: Re: Learning about WITH RECURSIVE