Postgres Pro
Downloads
Home   >   mailing lists

Re: get branches & childs from database - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: get branches & childs from database
Date
Msg-id 20041218092633.GA11248@winnie.fuhr.org
Whole thread Raw
In response to get branches & childs from database  (Marcus Krause <marcus.k79@expires-2004-12-31.arcornews.de>)
List pgsql-sql
Tree view 
On Thu, Dec 16, 2004 at 10:23:23PM +0100, Marcus Krause wrote:

> I'm trying to build up a menu by sending ONE query to database.

See the contrib/ltree module in the PostgreSQL source, or in
whatever package you must install to get the contributed modules.
ltree provides easy ways to query tree-like structures.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-sql by date:

Previous
From: Mark Collette
Date:
Subject: Updating column to link one table to another
Next
From: drdani@mazsola.iit.uni-miskolc.hu
Date:
Subject: diff databases