Hierarchical query's

 

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