Thread: Tree traversing. Like Oracle START WITH...CONNECT BY

Tree traversing. Like Oracle START WITH...CONNECT BY

From
"My Internet"
Date:
Hello,

I want to know if in PostgreSQL, there is a command equivalent to START
WITH... CONNECT BY from Orcale?
This command is used to traverse a tree.

Thank you,
Jean-Marc

_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus


Re: Tree traversing. Like Oracle START WITH...CONNECT BY

From
Pavel Stehule
Date:
Hello

PostgreSQL don't support Oracle tree extensions. You can try this patch
http://gppl.terminal.ru/readme.html.

ps

On Mon, 6 Oct 2003, My Internet wrote:

> Hello,
>
> I want to know if in PostgreSQL, there is a command equivalent to START
> WITH... CONNECT BY from Orcale?
> This command is used to traverse a tree.
>
> Thank you,
> Jean-Marc
>
> _________________________________________________________________
> MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
> http://join.msn.com/?page=features/virus
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>


Re: Tree traversing. Like Oracle START WITH...CONNECT BY

From
Richard Huxton
Date:
On Monday 06 October 2003 09:13, Pavel Stehule wrote:
> Hello
>
> PostgreSQL don't support Oracle tree extensions. You can try this patch
> http://gppl.terminal.ru/readme.html.

I think there's something in contrib/tablefunc
--
  Richard Huxton
  Archonet Ltd