Hierarchical Queries

From: "Gautham S(dot) Rao" <gautam(dot)rao(at)tatainfotech(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Hierarchical Queries
Date: 2002-04-09 13:04:29
Message-ID: 014b01c1dfc7$155480b0$41057aa3@tatainfotech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

Can someone tell me how to write a hierarchical query in pgsql. What I want is something like the '...CONNECT BY PRIOR ... START WITH....' clause which is available in Oracle.

Regards,
Gautham.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-04-09 13:33:55 Re: Scadinavian characters in regular expressions
Previous Message Christopher Kings-Lynne 2002-04-09 13:01:16 Re: Hierarchical Queries