Re: WITH RECURSIVE doesn't work properly for me - Mailing list pgsql-general

From Jing Fan
Subject Re: WITH RECURSIVE doesn't work properly for me
Date
Msg-id CA+BectmwK1iQPmH+EtXdx2x5c6odmSp0dz3h+U92tnRJa=eGGQ@mail.gmail.com
Whole thread Raw
In response to Re: WITH RECURSIVE doesn't work properly for me  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Responses Re: WITH RECURSIVE doesn't work properly for me
List pgsql-general
Why the one inside does not do anything? It won't be executed?

Best,
Jing


On Tue, Nov 5, 2013 at 8:52 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
Jing Fan wrote:
> I have two group operations.
>
> One is inside the CTE (   union
>                                    select src_id, dest_id, min(dist) ),
> another is outside the CTE.
> Do you mean that even the grouping inside the CTE will be calculated only after the CTE has been
> calculated?

I mean the one outside the CTE.

The one inside does not do anything at all, you could omit it.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Junk date getting uploaded into date field
Next
From: Michael Nolan
Date:
Subject: Re: Junk date getting uploaded into date field