Hierarchical query's

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

Hello

PostgreSQL doesn't support h.q and I will not support this type of h.q.
Supported syntax will be like db2 - ANSI SQL 2kx. But you can try hier
patch - http://gppl.terminal.ru/readme.html.

This is a patch which allows PgSQL to perform hierarchical queries like
Oracle does.

Regards
Pavel Stehule

On Thu, 23 Oct 2003, [iso-8859-1] Cl�udia Morgado wrote:

Thanks very much!

We will go to do the tests.

Regards,
Carla Mello and Cl�udia Morgado

----- Original Message -----
From: "Pavel Stehule" <stehule@kix.fsv.cvut.cz>
To: "Cl�udia Morgado" <claudia.morgado@widesoft.com.br>
Cc: <pgsql-general@postgresql.org>; <cmmello@wide.com.br>
Sent: Friday, October 24, 2003 3:32 AM
Subject: Re: [GENERAL] Hierarchical query's

Hello

PostgreSQL doesn't support h.q and I will not support this type of h.q.
Supported syntax will be like db2 - ANSI SQL 2kx. But you can try hier
patch - http://gppl.terminal.ru/readme.html.

This is a patch which allows PgSQL to perform hierarchical queries like
Oracle does.

Regards
Pavel Stehule

On Thu, 23 Oct 2003, [iso-8859-1] Cl�udia Morgado wrote:

Hello!

Oracle has the option with the SQL CONECT BY statement to run through a

hierarchical database with a single SQl-statement:

<!--SQL SELECT ms_id,ms_parent FROM messages CONNECT BY PRIOR ms_id =

ms_parent START WITH ms_id = 1 -->