Help with a "recursive" query - Mailing list pgsql-sql

Hi,

I've got a table like this :

id        parent      description
01        00          xxxxxx
02        00          xxxxxx
03        01          xxxxxx
04        02          xxxxxx
05        01          xxxxxx
06        05          xxxxxx
07        03          xxxxxx
08        07          xxxxxx
09        00          xxxxxx
10        02          xxxxxx


I want to get all tuples which have id=01 as their parent
or ancestor, i.e. :
03, 05, 06, 07, 08

this to represent a sort of n-tree :
01      /  \     /    \    /      \   03      05  /          \ /            \/              \
07               06
|
|
|
08

this example is simple because each node has at most one child, but in
my real data there's no such limit.

any idea ?

thanks in advance

Jerome Alet