Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Learning about WITH RECURSIVE
Date
Msg-id 27333.1257372664@sss.pgh.pa.us
Whole thread Raw
In response to Learning about WITH RECURSIVE  (Richard Broersma <richard.broersma@gmail.com>)
Responses Re: Learning about WITH RECURSIVE  (Richard Broersma <richard.broersma@gmail.com>)
Re: Learning about WITH RECURSIVE  (Richard Broersma <richard.broersma@gmail.com>)
List pgsql-sql
Tree view 
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 ...
        regards, tom lane

pgsql-sql by date:

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