| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Gautham S(dot) Rao" <gautam(dot)rao(at)tatainfotech(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Hierarchical Queries |
| Date: | 2002-04-09 13:01:16 |
| Message-ID: | 20020409210001.U25932-100000@houston.familyhealth.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
You can't - that syntax is not implemented in Postgres.
The only alternative is to try and write a stored procedure that uses a
FOR loop. Remember that you can only return an open cursor from pl/pgsql,
not an actual recordset.
Chris
On Tue, 9 Apr 2002, Gautham S. Rao wrote:
> 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.
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gautham S. Rao | 2002-04-09 13:04:29 | Hierarchical Queries |
| Previous Message | Andreas Joseph Krogh | 2002-04-09 12:14:49 | Re: replace NULL |