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 > > > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
