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.
>
>