Hi people, I need to know if Postgres do recursive search and how can I do! I will explain my problem. table COOPERATIVE code_cooperative int code_coo_father int I can have 3 level by business rules 1 - Father ----- 2 - Children --------- 3 - Grandchildren I would like to have a query asking who is father and granfather select grandfather, father from COOPERATIVE where COD_COOPERATIVE = 3 Do the Postgres can solve this problem? Could anybody help me? Thank you
