There is a contrib module named tablefunc. It has a function
connect_by that can do some things like this. Check if it is
sufficient for you.
--Imad
www.EnterpriseDB.com
On 2/10/07, Alexander B. <[EMAIL PROTECTED]> wrote:
Hi, I need to create a view using hierarchical structure.
Let me explain
Hi, I need to create a view using hierarchical structure.
Let me explain how is designed the table and what's the expected result.
TABLE:
coo_nro integer
coo_nro_father integer
level integer
DATA:
100 – null – 1
106 – null – 1
134 – 100 – 2
725 – 100 – 2
635 – 106 – 2
423 – 134 – 3
814 – 725 – 3
