at 2:13 AM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
Jing Fan wrote:
If the grouping inside CTE is executed, I don't think it would generate
result like
src_id | dest_id | dist
+-+--
3384 |6236 |1
3384 |1739 |2
3384 |6236 |3
AM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
Jing Fan wrote:
I am sorry but I still don't understand why it doesn't work. Possibly I
misunderstand how with
recursive works?
In my opinion,
with recursive table as{
seed statement
union
recursive statement
}
In every
Yeah, that can explain why it doesn't work.
Thank you very much:)
On Wed, Nov 6, 2013 at 8:40 AM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
Jing Fan wrote:
On Wed, Nov 6, 2013 at 8:10 AM, Albe Laurenz laurenz.a...@wien.gv.at
wrote:
Let's assume that we have three nodes A, B and C
,
Jing
On Tue, Nov 5, 2013 at 5:04 AM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
Jing Fan wrote:
I use following command to get a shortest-path query:
with recursive paths( src_id, dest_id, dist) as(
select n1,n2,1
from nodes
union
select src_id
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.a...@wien.gv.atwrote:
Jing Fan wrote:
I have two group operations.
One is inside the CTE ( union
select src_id, dest_id
(). It actually generate no new
tuples and the iteration should stop.
Best,
Jing
On Tue, Nov 5, 2013 at 9:28 AM, Albe Laurenz laurenz.a...@wien.gv.atwrote:
Jing Fan wrote:
Why the one inside does not do anything? It won't be executed?
It is executed.
It might filter out the occasional row
I use following command to get a shortest-path query:
with recursive paths( src_id, dest_id, dist) as(
select n1,n2,1
from nodes
union
select src_id, dest_id, min(dist)
from ( select paths.src_id as src_id, nodes.n2 as dest_id,
paths.dist+1 as dist