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 are too 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 their way 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 takes care of bugfixes (and possibly also feature requests like sql99 compliance?), i.e. this might be a realistic startingpoint for 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 recursive queries. it would be interesting to know andrews opinion how much more work would be needed to get a SQL99 compliant version out based on the work he has done so far, and what he thinks about Evgen potemkin's patch (i cced this mail to 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 towards a feature that many users like me are missing for a long time already... regards, jacob koehler ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
