Postgres Pro
Downloads
Home   >   mailing lists

Recursive select - Mailing list pgsql-sql

From Jason Kwok
Subject Recursive select
Date
Msg-id 00af01c15deb$74289940$0201a8c0@newhonest.com
Whole thread Raw
Responses Re: Recursive select  (Esteban Gutierrez Abarzua <esgutier@sauce.chillan.ubiobio.cl>)
Re: Recursive select  (Roberto Mello <rmello@cc.usu.edu>)
List pgsql-sql
Tree view 
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



---
Virus Free
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.286 / Virus Database: 152 - Release Date: 2001/10/9

pgsql-sql by date:

Previous
From: "Valdir H. Dias Leite"
Date:
Subject: SQL99
Next
From: Thomas Swan
Date:
Subject: Re: Granting database level permissions...