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