Postgres Pro
Downloads
Home   >   mailing lists

Re: Recursive use - Mailing list pgsql-admin

From Aaron Bono
Subject Re: Recursive use
Date
Msg-id bf05e51c0610131425w5153b18wcdb09d84c3affdbc@mail.gmail.com
Whole thread Raw
In response to Recursive use  (Alexander Burbello <burbello3000@yahoo.com.br>)
List pgsql-admin
Tree view
On 10/4/06, Alexander Burbello <burbello3000@yahoo.com.br> wrote:
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?

I see this question every few months.

Check out this post: http://archives.postgresql.org/pgsql-sql/2001-11/msg00438.php

--
==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
==================================================================

pgsql-admin by date:

Previous
From: Chris Browne
Date:
Subject: Re: postgres in HA constellation
Next
From: "Aaron Bono"
Date:
Subject: Re: Copying data from table to table (cloned tables)