Re: Learning about WITH RECURSIVE

Поиск
Список
Период
Сортировка
От Richard Broersma
Тема Re: Learning about WITH RECURSIVE
Дата
Msg-id 396486430911041417o40cf1939k6ff703ca704a3e14@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Learning about WITH RECURSIVE  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Learning about WITH RECURSIVE
Следующее
От: Richard Broersma
Дата:
Сообщение: Re: Learning about WITH RECURSIVE