[Pgsql-ayuda] Consulta Jerarquica (Correccion)
Andres Garcia Jimenez
agarcia@ids.com.mx
Tue, 2 Dec 2003 18:34:27 -0600
U2FsdWRvczoNClVuYSBkaXNjdWxwYSBwb3IgZWwgZW52aW8gcGFzYWRvIG5vIHNlIGJpZW4gcXVl
IHN1Y2VkaW8geSBwb3IgcXVlIGVudsOtbyBwdXJhIGJhc3VyYS4NCg0KUXVpc2llcmEgdmVyIHNp
IGFsZ3VpZW4geWEgaGEgcmVhbGl6YWRvIGNvbnN1bHRhcyBqZXJhcnF1aWNhcyBlbiBQb3N0Z3Jl
cyAoQWxnbyBwYXJlY2lkbyBhbCBDb25uZWN0IGJ5IGRlIE9yYWNsZSksIHkgY29tbyBlcyBxdWUg
bG8gaGFuIGhlY2hvLCBhZ3JlZGVjZXJlIGN1YWxxdWllciBheXVkYSB5YSBxdWUgc295IG51ZXZv
IGVuIHBvc3RncmVzcw0KIA0KUG9yIG1pIHBhdHJ0ZSBlc3RveSBpbnRlbnRhbmRvIHJlc29sdmVy
bG8gY29uIHVuYSBmdW5jaW9uIGRlIFBMcGdTUUwgDQogDQpFc3RveSB1dGlsaXphbmRvIHVuYSBU
RU1QT1JBUlkgVEFCTEUgbGxhbWFkYSBhcmJvbCB5IGxhIGxsZW5vIGNvbiBhbGdvIGNvbW8gbG8g
c2lndWllbnRlOg0KIA0KLyogSW5zZXJ0YW5kbyBsYSBSYWl6IGRlbCBBcmJvbCAqLw0KICAgIGlu
c2VydCBpbnRvIGFyYm9sIHNlbGVjdCBtb2RfaWQsIG1vZF9kZXNjcmlwY2lvbiwgb3JkZW4sbXlu
aXZlbCxtb2RfaWRfZmsgDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgIGZyb20gc2VnX21v
ZHVsbw0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICB3aGVyZSBtb2RfaWRfZmsgaXMgbnVs
bDsNCiAgICBHRVQgRElBR05PU1RJQ1MgbnVtX3JlZyA9IFJPV19DT1VOVDsNCiAgDQogIFdISUxF
IG51bV9yZWc+MCBMT09QDQogLyogUGFzbyBhbCBzaWd1aWVudGUgbml2ZWwgZGVsIGFyYm9sICov
DQogICAgIG15bml2ZWw6PW15bml2ZWwrMTsNCiAgICAgb3JkZW46PW9yZGVuKzE7DQogLyogSW5z
ZXJ0byBlbCBzaWd1aWVudGUgbml2ZWwgZGVsIGFyYm9sIGRvbmRlIGVsIHBhZHJlIHNvbiBsbyBy
ZWcgZGVsIG5pdmVsIGFudGVyaW9yICovDQogaW5zZXJ0IGludG8gYXJib2wgDQogc2VsZWN0IG1v
ZF9pZCwgbW9kX2Rlc2NyaXBjaW9uLCBvcmRlbixteW5pdmVsLG1vZF9pZF9mayBmcm9tIHNlZ19t
b2R1bG8gDQogd2hlcmUgbW9kX2lkX2ZrIGluIChzZWxlY3QgaWQgZnJvbSBhcmJvbCB3aGVyZSBu
aXZlbD1teW5pdmVsLTEpOw0KIC8qIFZhbGlkbyBzaSBodWJvIHJlZ2lzdHJvcyBxdWUgcHVkaWVy
YW4gdGVuZXIgbWFzIGhpam9zICovDQogR0VUIERJQUdOT1NUSUNTIG51bV9yZWcgPSBST1dfQ09V
TlQ7DQogICAgRU5EIExPT1A7DQogICAgUkVUVVJOIE5FWFQgU0VMRUNUIGlkLGRlc2NyaXBjaW9u
LG9yZGVuLG5pdmVsLHBhZHJlIEZST00gYXJib2w7ICAgICANCiAgICBSRVRVUk47DQpVbmEgdmV6
IGhlY2hvIGVzdG8gdHJhdG8gZGUgb2J0ZW5lciBsb3MgdmFsb3JlcyBjb24gdW5hIGNvbnN1bHRh
IGNvbW8gbGEgc2lndWllbnRlOg0KIA0KU0VMRUNUICogRlJPTSBGTl9BUkJPTCgpOw0KIA0KRWwg
cHJvYmxlbWEgZXMgcXVlIG5vIG1lIHRyYWUgbmluZ3VuIHJlZ2lzdHJvIHBlc2UgYSBxdWUgbGEg
dGFibGEgdGVtcG9yYWwgc2kgY29udGllbmUgbG9zIHJlZ2lzdHJvcywgwr9ubyBzZSBzaSBlc3Rv
eSB1dGlsaXphbmRvIGNvcnJlY3RhbWVudGUgZWwgUkVUVVJOIE5FWFQ/IG8gcXVlIGVzdGEgcGFz
YW5kbywgc2kgYWxndWllbiB0aWVuZSB1bmEgaWRlYSBvIGNvbWVudHJhaW8gc2UgbG9zIGFncmFk
ZWNlcmUNCiANCmJ1ZW5vIGNvbW8gZGlqZSBhbnRlcyBhZ3JhZGVjZXNjbyBjdWFscXVpZXIgYXl1
ZGEgDQoNCg==