BE carefull you have a number of limitation with recursive cte (I'm thinking of update and so.) You can work around with plpgsql but it might be painfull.
You forgot a solution : if you need powerfull graph features, use postgres as a database and a SPARQL speaking frontend. It may be a bit of overkill ;-) Cheers, Rémi-C 2013/9/23 Kaare Rasmussen <ka...@jasonic.dk> > Hi Alban > > > 4. Using a recursive common table expression (CTE). >> http://www.postgresql.org/**docs/9.2/static/queries-with.**html<http://www.postgresql.org/docs/9.2/static/queries-with.html> >> > > Yes, you're right. In fact that's what I'm testing a way to replace, as > I'm not confident in the performance in all situations. My fault entirely; > I should have told so from the start. > > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general> >
