consulta recursiva 3

     +---->B(0,1)
     |
     +---->C(0,2)  +-->F(3,5)
     |	    	   |
     +---->D(0,3)--+-->G(3,6)
     |		   |
A----+             +-->H(3,7)
     |			      +->M(8,12)
     |			      |
     +---->E(0,4)--+-->I(4,8)-+->N(8,13)   +-->M(14,19)
		   |		           |
     		   |	      +->I(9,14)---+-->N(14,20)
		   |          |
     		   +-->J(4,9)-+->P(9,15)	         +---->Y(21,25)
		   |				         |
		   |	      	 	  +--->U(16,21)--+---->X(21,26)
		   |	                  |
		   +-->K(4,10)+->R(10,16)-+--->V(16,22)
		   |	      |
		   |	      +->S(10,17) 	         +---->Y(23,27)
		   |			     	         |
		   +-->L(4,11)+->R(11,18)-+--->U(18,23)--+---->X(23,28)
					  |
			      		  +--->V(18,24)

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

CONSULTA SIN TERMINAR:
----------------------
Se debe generar un id único donde dice --id_único

WITH RECURSIVE compuesta (Madre, Hijo, id) AS
            (
             SELECT madre, hijo,
                            ARRAY[0, --id_único] AS id_madre
             FROM componente_mc WHERE madre = A
              UNION ALL
              SELECT componente_mc.madre, componente_mc.hijo,
                            ARRAY[id_madre[2], --id_único],
                 FROM componente_mc, compuesta
             WHERE componente_mc.madre = compuesta.hijo
            )
            SELECT Hijo, Madre
            FROM compuesta


DEBERÏA RESULTAR ASÍ:
NOTA ID (ID PADRE, ID PROPIO)


| Hijo | Padre |  ID HIJO  |
|------+-------|-----------|
| B    | A     | (0,1)     |
| C    | A     | (0,2)     |
| D    | A     | (0,3)     |
| E    | A     | (0,4)     |
| F    | D     | (3,5)     |
| G    | D     | (3,6)     |
| H    | D     | (3,7)     |
| I    | E     | (4,8)     |
| J    | E     | (4,9)     |
| K    | E     | (4,10)    |
| L    | E     | (4,11)    |
| M    | I     | (8,12)    |
| N    | I     | (8,13)    |
| I    | J     | (9,14)    |
| P    | J     | (9,15)    |
| R    | K     | (10,16)   |
| S    | K     | (10,17)   |
| R    | L     | (11,18)   |
| M    | I     | (14,19)   |
| N    | I     | (14,20)   |
| U    | T     | (16,21)   |
| V    | T     | (16,22)   |
| U    | T     | (18,23)   |
| V    | T     | (18,24)   |
| Y    | U     | (21,25)   |
| X    | U     | (21,26)   |
| Y    | U     | (23,27)   |
| X    | U     | (23,28)   |