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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

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