Re: Tree structure

Поиск
Список
Период
Сортировка
От Rémi Cura
Тема Re: Tree structure
Дата
Msg-id CAJvUf_u5TvyT_JF69cn6ewf+AFonhx-h3dQhbDPsjYTAwBkC8Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Tree structure  (Kaare Rasmussen <kaare@jasonic.dk>)
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Raphael Bauduin
Дата:
Сообщение: passing multiple records to json_populate_recordset
Следующее
От: Raphael Bauduin
Дата:
Сообщение: Re: passing multiple records to json_populate_recordset