| From: | Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz> |
|---|---|
| To: | Cláudia Morgado <claudia(dot)morgado(at)widesoft(dot)com(dot)br> |
| Cc: | pgsql-general(at)postgresql(dot)org, <cmmello(at)wide(dot)com(dot)br> |
| Subject: | Re: Hierarchical query's |
| Date: | 2003-10-24 05:32:49 |
| Message-ID: | Pine.LNX.4.44.0310240727310.9738-100000@kix.fsv.cvut.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 -->
>
> Result-set (example):
>
> ms_id parent_id 1 1.1 1 1.1.1 1.1 1.1.2 1.1 1.1.3 1.1 1.2 1 1.2.1 1.2
>
> etc
>
>
> I need to do this in PostgreSql.
>
> This is possible in the Postgre?
>
>
> regards,
> Cláudia Morgado and Carla Mello
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Meskes | 2003-10-24 07:06:16 | Re: Clustering for performance and fail over |
| Previous Message | Nagib Abi Fadel | 2003-10-24 05:31:57 | ERROR: Multiple assignments to same attribute... ?? |