Re: How to navigate tree without CONNECT BY?

From: Joe Conway <mail(at)joeconway(dot)com>
To: "D(dot) Dante Lorenso" <dante(at)lorenso(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to navigate tree without CONNECT BY?
Date: 2003-12-18 18:34:58
Message-ID: 3FE1F352.8010000@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

D. Dante Lorenso wrote:
> I have a simple table that I'd like to query to pull
> out a heirarchy from a tree relationship. What is the
> best way to do this without a 'CONNECT BY' clause like
> Oracle has?

See connectby() in contrib/tablefunc.

Joe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Twombley 2003-12-18 19:37:12 Has anyone seen an ADO Provider for Postresql?
Previous Message Ron St-Pierre 2003-12-18 18:19:57 Re: Function Returning SETOF Problem