Groups > comp.databases.postgresql > #822

Re: Postgres 9.6 - ltree extension - (re)build a tree on a table

From	Dimitri Fontaine <dim@tapoueh.org>
Newsgroups	comp.databases.postgresql
Subject	Re: Postgres 9.6 - ltree extension - (re)build a tree on a table
Date	2018-04-17 23:31 +0200
Organization	A noiseless patient Spider
Message-ID	<m2lgdl34h7.fsf@tapoueh.org> (permalink)
References	<f1e640c3-d6a7-4a19-af0e-1a7dfa54d65d@googlegroups.com>

Show all headers | View raw

lordluke80@gmail.com writes:
> Any suggestion to achieve that or snippets about how to do that? havent foud any valid example for 'rebuild a tree in postgres' in the official docs.

Have a look at WITH RECURSIVE:

  https://www.postgresql.org/docs/current/static/queries-with.html
  https://tapoueh.org/blog/2018/01/exporting-a-hierarchy-in-json-with-recursive-queries/
  
Regards,
-- 
Dimitri Fontaine

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Postgres 9.6 - ltree extension - (re)build a tree on a table lordluke80@gmail.com - 2018-04-17 01:44 -0700
  Re: Postgres 9.6 - ltree extension - (re)build a tree on a table Dimitri Fontaine <dim@tapoueh.org> - 2018-04-17 23:31 +0200
    Re: Postgres 9.6 - ltree extension - (re)build a tree on a table lordluke80@gmail.com - 2018-04-19 14:45 -0700

csiph-web