Re: [GENERAL] Hierarchical query's

2003-10-24 Thread Pavel Stehule
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

Re: [GENERAL] Hierarchical query's

2003-10-24 Thread Greg Stark
Cláudia Morgado <[EMAIL PROTECTED]> 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