Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group