Re: [HACKERS] WITH RECURSIVE updated to CVS TIP
Tatsuo Ishii <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.patches,gmane.comp.db.postgresql.devel.general |
|---|---|
| Message-ID | <[email protected]> |
> On Tue, Jul 08, 2008 at 06:01:05PM +0900, Tatsuo Ishii wrote: > > Here is the patches he made against CVS HEAD (as of today). > > > > According to him followings are fixed with the patches: > > > > - fix crush with DISTINCT > > - fix creating VIEW > > - fix the case when recursion plan has another recursion plan under it > > - fix WITH RECURSIVE ...(..) SELECT ...WHERE.. returns wrong result > > - fix inifinit recursion with OUTER JOIN > > Great! > > I've patched psql for some partial support of WITH [RECURSIVE]. > > http://git.postgresql.org/?p=~davidfetter/postgresql/.git;a=commit;h=da63f9a82b9e902b5542f788b2e6e6bc95221793 Thanks. I will incorporate them with propsed patches. > > Not yet fixed: > > > > - detect certain queries those are not valid acroding to the standard > > - sort query names acording to the dependency > > Is there something in the standard on how to do this? How to sort the > nodes other ways? No idea. What do you think if we allow only one query name at the moment. I guess most WITH RECURISVE use cases are enough with single query name. -- Tatsuo Ishii SRA OSS, Inc. Japan -- Sent via pgsql-patches mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-patches