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

From Albe Laurenz
Subject Re: WITH RECURSIVE doesn't work properly for me
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17C56925@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to Re: WITH RECURSIVE doesn't work properly for me  (Jing Fan <fanjing09@gmail.com>)
Responses Re: WITH RECURSIVE doesn't work properly for me
List pgsql-general
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: Albe Laurenz
Date:
Subject: Re: Curious question about physical files to store database
Next
From: Tom Lane
Date:
Subject: Re: Junk date getting uploaded into date field