Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- +---->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) |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement