recursive SQL
От | jacob koehler (RRes-Roth) |
---|---|
Тема | recursive SQL |
Дата | |
Msg-id | EFDAAE7F4B83D243868A2F25AD8A4B38A56E77@rothe2ksrv1.rothamsted.bbsrc.ac.uk обсуждение исходный текст |
Ответы |
Re: recursive SQL
Re: recursive SQL Re: recursive SQL |
Список | pgsql-hackers |
hi, i am wondering what you think about including evgen potemkin's patch for recursive SQL in the next postgres version: http://gppl.terminal.ru/ cons: - its not standard SQL (uses oracle style syntax) pros: - it would add a feature that many people miss already for ages. all existing workarounds are a pain in the ass, and aretoo slow for realistic applications. - full SQL99 compliant recursive queries are much more complex, i.e. i think it is even unlikely that they will find theirway into 7.6. - Evgen DID publish this patch under GPL, see: http://gppl.terminal.ru/README.html - the code doesnt look too bad (although im not the right person to judge such things), and it seems the developer takescare of bugfixes (and possibly also feature requests like sql99 compliance?), i.e. this might be a realistic startingpointfor SQL99 compliant recursive queries. i am aware of the fact that tom lane pointed to the fact that Andrew Overholt did work towards SQL99 compliant recursivequeries. it would be interesting to know andrews opinion how much more work would be needed to get a SQL99 compliantversion out based on the work he has done so far, and what he thinks about Evgen potemkin's patch (i cced this mailto Andrew and Evgen). in summary, i think Evgens patch would cover 95% of all user needs, and releasing it with 7.5 would be a realistic step towardsa feature that many users like me are missing for a long time already... regards, jacob koehler
В списке pgsql-hackers по дате отправления: