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

Re: Querying Hierarchical Data

From: Joe Conway <mail(at)joeconway(dot)com>
To: Eric <someone(at)somewhere(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Querying Hierarchical Data
Date: 2003-03-03 18:25:26
Message-ID: 3E639E16.500@joeconway.com (view raw or flat)
Thread:
Lists: pgsql-sql
Eric wrote:
> How do I access hierarchical data under PostgreSQL?
> Does it have SQL command similar to Oracle's CONNECT BY?
> 

In addition to all the other good suggestions, if you are using Postgres 
version 7.3.x, take a look at contrib/tablefunc for a function called 
connectby().

HTH,

Joe


In response to

pgsql-sql by date

Next:From: Josh BerkusDate: 2003-03-03 18:30:11
Subject: Re: OUTER JOIN with filter
Previous:From: Erwin MollerDate: 2003-03-03 18:24:15
Subject: Re: HardCORE QUERY HELP!!!

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