Re: Common Table Expressions (WITH RECURSIVE) patch - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: Common Table Expressions (WITH RECURSIVE) patch
Date
Msg-id 20080919.103251.77346237.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: Common Table Expressions (WITH RECURSIVE) patch  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Common Table Expressions (WITH RECURSIVE) patch  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Why does set_recursion_pathlist think that the subquery might have
> useful pathkeys?  We know it must always be a UNION ALL, no?

Right. But someday we might implement "UNION" (without ALL) then we
have useful pathkeys...

Or shall I completely remove the step to generate patheys and do not
pass pathkeys to create_recursion_path?
pathkeys = convert_subquery_pathkeys(root, rel, subroot->query_pathkeys);
--
Tatsuo Ishii
SRA OSS, Inc. Japan


pgsql-hackers by date:

Previous
From: Joshua Drake
Date:
Subject: Re: Do we really need a 7.4.22 release now?
Next
From: Robert Treat
Date:
Subject: Re: Where to Host Project