Postgres Pro
Downloads
Home   >   mailing lists

Re: Tree structure - Mailing list pgsql-general

From Rémi Cura
Subject Re: Tree structure
Date
Msg-id CAJvUf_u5TvyT_JF69cn6ewf+AFonhx-h3dQhbDPsjYTAwBkC8Q@mail.gmail.com
Whole thread Raw
In response to Re: Tree structure  (Kaare Rasmussen <kaare@jasonic.dk>)
List pgsql-general
Tree view
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 <kaare@jasonic.dk>
Hi Alban


4. Using a recursive common table expression (CTE). 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

pgsql-general by date:

Previous
From: Raphael Bauduin
Date:
Subject: passing multiple records to json_populate_recordset
Next
From: Raphael Bauduin
Date:
Subject: Re: passing multiple records to json_populate_recordset