The only code that is usable (and performant) is the CONNECT BY patch made by Evgen Potemkin, It works on production servers on the 8.1.5
I hope that a WITH RECURSIVE will be in the 8.3... but I don't see anybody working on this... (what a shame...) Le mercredi 24 janvier 2007 à 17:27 +0000, Gregory Stark a écrit : > I'm looking into recursive queries and what it would take to support them in > Postgres. Is anyone else looking at this already? > > Aside from the Oracle-ish syntax were there other objections to the patch as > posted a while back for 7.3 by Evgen Potemkin? > > I have some ideas myself for how to go about this but I'm going to review the > existing patch first. If anyone else has ideas I would like to hear them. > _______________________________________________ Ce message et les �ventuels documents joints peuvent contenir des informations confidentielles. Au cas o� il ne vous serait pas destin�, nous vous remercions de bien vouloir le supprimer et en aviser imm�diatement l'exp�diteur. Toute utilisation de ce message non conforme � sa destination, toute diffusion ou publication, totale ou partielle et quel qu'en soit le moyen est formellement interdite. Les communications sur internet n'�tant pas s�curis�es, l'int�grit� de ce message n'est pas assur�e et la soci�t� �mettrice ne peut �tre tenue pour responsable de son contenu.