consulta recursiva 2

Colocandole id a los productos:

     +---->B(1,1)
     |
     +---->C(2,2)  +-->F(3,1)
     |	    	   |
     +---->D(3,3)--+-->G(3,2)
     |		   |
A----+             +-->H(3,3)
     |			      +-->M(4,1)
     |			      |
     +---->E(4,4)--+-->I(4,1)-+-->N(4,2)  +--->M(4,1)
		   |		          |
     		   |	      +-->I(4,1)--+--->N(4,2)
		   |          |
     		   +-->J(4,2)-+-->P(4,2)	      +---->Y(4,1)
		   |				      |
		   |	      	 	  +--->U(4,1)-+---->X(4,2)
		   |	                  |
		   +-->K(4,3)-+-->R(4,1)--+--->V(4,2)
		   |	      |
		   |	      +-->S(4,2)	      +---->Y(4,1)
		   |			     	      |
		   +-->L(4,4)-+-->R(4,1)--+--->U(4,1)-+---->X(4,2)
					  |
			      		  +--->V(4,2)

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

CONSULTA:
WITH RECURSIVE compuesta (Madre, Hijo) AS
		    (
		     SELECT madre, hijo,
                            ARRAY[row_number() over (), row_number() over (), 1] AS id_madre
		     FROM componente_mc WHERE madre = A
	 	     UNION ALL
	 	     SELECT componente_mc.madre, componente_mc.hijo,
                            ARRAY[compuesta.id_madre[1], row_number() over (), compuesta.id_madre[2]+1],
	             FROM componente_mc, compuesta
		     WHERE componente_mc.madre = compuesta.hijo
		    )
		    SELECT Hijo, Madre
		    FROM compuesta



RESULTADO:
NOTA ID (N° Rama, N°ID, N°Generacion)


| Hijo | Padre |  ID HIJO  |
|------+-------|-----------|
| B    | A     | (1,1,1)   |
| C    | A     | (2,2,1)   |
| D    | A     | (3,3,1)   |
| E    | A     | (4,4,1)   |
| F    | D     | (3,1,2)   |
| G    | D     | (3,2,2)   |
| H    | D     | (3,3,2)   |
| I    | E     | (4,1,2)   |
| J    | E     | (4,2,2)   |
| K    | E     | (4,3,2)   |
| L    | E     | (4,4,2)   |
| M    | I     | (4,1,3)   |
| N    | I     | (4,2,3)   |
| I    | J     | (4,1,3)   |
| P    | J     | (4,2,3)   |
| R    | K     | (4,1,3)   |
| S    | K     | (4,2,3)   |
| R    | L     | (4,1,3)   |
| M    | I     | (4,1,4)   |
| N    | I     | (4,2,4)   |
| U    | T     | (4,1,4)   |
| V    | T     | (4,2,4)   |
| U    | T     | (4,1,4)   |
| V    | T     | (4,2,4)   |
| Y    | U     | (4,1,5)   |
| X    | U     | (4,2,5)   |
| Y    | U     | (4,1,5)   |
| X    | U     | (4,2,5)   |