Horton

Re: Recursive select

Esteban Gutierrez Abarzua <esgutier@sauce.chillan.ubiobio.cl>

View thread View on postgr.es
From: Esteban Gutierrez Abarzua <esgutier@sauce.chillan.ubiobio.cl>
To: Jason Kwok <jason@newhonest.com>
Cc: pgsql-sql@postgresql.org
Date: 2001-10-29T18:57:37Z
Lists: pgsql-sql 
On Fri, 26 Oct 2001, Jason Kwok wrote:

> I have a table :
> 
> MyID           parentID
> ================
> 5                    6
> 6                    7
> 3                    13
> 7                    3
> 
> Is there any simple select statement that can get all rows with MyID = 5 and
> all its parents?
> That means 5's parenet is 6, 6's parent is 7, 7's parent is 3.....
> 
> 
> Jason
> 
I think that this is not possible.

You may do it using sql embedded or jdbc!


bye.