Recursive use

Поиск
Список
Период
Сортировка
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

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Sebastian Reitenbach"
Дата:
Сообщение: postgres in HA constellation
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: postgres in HA constellation