Re: Learning about WITH RECURSIVE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
Cc: sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Learning about WITH RECURSIVE
Date: 2009-11-04 22:11:04
Message-ID: 27333.1257372664@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Richard Broersma <richard(dot)broersma(at)gmail(dot)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 ...

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Broersma 2009-11-04 22:17:00 Re: Learning about WITH RECURSIVE
Previous Message Richard Broersma 2009-11-04 22:03:33 Learning about WITH RECURSIVE