Re: Hierarchical query's - Mailing list pgsql-general

From Greg Stark
Subject Re: Hierarchical query's
Date
Msg-id 87k76v1ef1.fsf@stark.dyndns.tv
Whole thread Raw
In response to Hierarchical query's  (Cláudia Morgado <claudia.morgado@widesoft.com.br>)
List pgsql-general
Cláudia Morgado <claudia.morgado@widesoft.com.br> writes:

> Oracle has the option with the SQL CONECT BY statement to run through a
> hierarchical database with a single SQl-statement:

Not really.

There is a package in the contrib directory called tablefunc that has a
function called connect_by that can do some things like this. I have no
experience with it and don't know if it would meet your needs.

--
greg

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Desperate help needed for Replication
Next
From: Andrew Rawnsley
Date:
Subject: Re: Setting up DSPACE for Postgres access