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