Re: get branches & childs from database

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Marcus Krause <marcus(dot)k79(at)expires-2004-12-31(dot)arcornews(dot)de>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: get branches & childs from database
Date: 2004-12-18 09:26:33
Message-ID: 20041218092633.GA11248@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message drdani 2004-12-18 14:23:13 diff databases
Previous Message Richard Huxton 2004-12-17 16:43:14 Re: can't get the order I want after inserting new rows