consulta recursiva 1

Dado el siguiente esquema:

     +---->B
     |
     +---->C	 +-->F
     |	    	 |
     +---->D-----+-->G
     |		 |
A----+           +-->H
     |			  +-->M
     |			  |
     +---->E-----+-->I----+-->N	    +--->M
		 |		    |
     		 |	  +-->I-----+--->N
		 |        |
     		 +-->J----+-->P		     +---->Y
		 |			     |
		 |	 +--->Q	   +--->U----+---->X
		 |	 |     	   |
		 +-->K---+--->T----+--->V
		 |	 |
		 |	 +--->S		     +---->Y
		 |			     |
		 +-->L---+--->T----+--->U----+---->X
				   |
				   +--->V

0---------1----------2--------3---------4----------5--->Generacion

CONSULTA:

WITH RECURSIVE compuesta (Madre, Hijo) AS
		    (
		     SELECT madre, hijo
		     FROM componente_mc WHERE madre = A
	 	     UNION ALL
	 	     SELECT componente_mc.madre, componente_mc.hijo
	             FROM componente_mc, compuesta
		     WHERE componente_mc.madre = compuesta.hijo
		    )
		    SELECT Hijo, Madre
		    FROM compuesta

RESULTADO:

| Hijo | Madre |
|------+-------|
| B    | A     |
| C    | A     |
| D    | A     |
| E    | A     |
| F    | D     |
| G    | D     |
| H    | D     |
| I    | E     |
| J    | E     |
| K    | E     |
| L    | E     |
| M    | I     |
| N    | I     |
| I    | J     |
| P    | J     |
| R    | K     |
| S    | K     |
| R    | L     |
| M    | I     |
| N    | I     |
| U    | T     |
| V    | T     |
| U    | T     |
| V    | T     |
| Y    | U     |
| X    | U     |
| Y    | U     |
| X    | U     |