[Pgsql-ayuda] Consulta jerarquica
Andres Garcia Jimenez
agarcia@ids.com.mx
Tue, 2 Dec 2003 10:39:19 -0600
U2FsdWRvczoNClF1aXNpZXJhIHZlciBzaSBhbGd1aWVuIHlhIGhhIHJlYWxpemFkbyBjb25zdWx0
YXMgamVyYXJxdWljYXMgZW4gUG9zdGdyZXMgKEFsZ28gcGFyZWNpZG8gYWwgQ29ubmVjdCBieSBk
ZSBPcmFjbGUpLCB5IGNvbW8gZXMgcXVlIGxvIGhhbiBoZWNobywgYWdyZWRlY2VyZSBjdWFscXVp
ZXIgYXl1ZGEgeWEgcXVlIHNveSBudWV2byBlbiBwb3N0Z3Jlc3MNCiANClBvciBtaSBwYXRydGUg
ZXN0b3kgaW50ZW50YW5kbyByZXNvbHZlcmxvIGNvbiB1bmEgZnVuY2lvbiBkZSBQTHBnU1FMIA0K
IA0KRXN0b3kgdXRpbGl6YW5kbyB1bmEgVEVNUE9SQVJZIFRBQkxFIGxsYW1hZGEgYXJib2wgeSBs
YSBsbGVubyBjb24gYWxnbyBjb21vIGxvIHNpZ3VpZW50ZToNCiANCi8qIEluc2VydGFuZG8gbGEg
UmFpeiBkZWwgQXJib2wgKi8NCiAgICBpbnNlcnQgaW50byBhcmJvbCBzZWxlY3QgbW9kX2lkLCBt
b2RfZGVzY3JpcGNpb24sIG9yZGVuLG15bml2ZWwsbW9kX2lkX2ZrIA0KICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICBmcm9tIHNlZ19tb2R1bG8NCiAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgd2hlcmUgbW9kX2lkX2ZrIGlzIG51bGw7DQogICAgR0VUIERJQUdOT1NUSUNTIG51bV9yZWcg
PSBST1dfQ09VTlQ7DQogIA0KICBXSElMRSBudW1fcmVnPjAgTE9PUA0KIC8qIFBhc28gYWwgc2ln
dWllbnRlIG5pdmVsIGRlbCBhcmJvbCAqLw0KICAgICBteW5pdmVsOj1teW5pdmVsKzE7DQogICAg
IG9yZGVuOj1vcmRlbisxOw0KIC8qIEluc2VydG8gZWwgc2lndWllbnRlIG5pdmVsIGRlbCBhcmJv
bCBkb25kZSBlbCBwYWRyZSBzb24gbG8gcmVnIGRlbCBuaXZlbCBhbnRlcmlvciAqLw0KIGluc2Vy
dCBpbnRvIGFyYm9sIA0KIHNlbGVjdCBtb2RfaWQsIG1vZF9kZXNjcmlwY2lvbiwgb3JkZW4sbXlu
aXZlbCxtb2RfaWRfZmsgZnJvbSBzZWdfbW9kdWxvIA0KIHdoZXJlIG1vZF9pZF9mayBpbiAoc2Vs
ZWN0IGlkIGZyb20gYXJib2wgd2hlcmUgbml2ZWw9bXluaXZlbC0xKTsNCiAvKiBWYWxpZG8gc2kg
aHVibyByZWdpc3Ryb3MgcXVlIHB1ZGllcmFuIHRlbmVyIG1hcyBoaWpvcyAqLw0KIEdFVCBESUFH
Tk9TVElDUyBudW1fcmVnID0gUk9XX0NPVU5UOw0KICAgIEVORCBMT09QOw0KDQogICAgUkVUVVJO
IE5FWFQgU0VMRUNUIGlkLGRlc2NyaXBjaW9uLG9yZGVuLG5pdmVsLHBhZHJlIEZST00gYXJib2w7
ICAgICANCiAgICBSRVRVUk47DQoNClVuYSB2ZXogaGVjaG8gZXN0byB0cmF0byBkZSBvYnRlbmVy
IGxvcyB2YWxvcmVzIGNvbiB1bmEgY29uc3VsdGEgY29tbyBsYSBzaWd1aWVudGU6DQogDQpTRUxF
Q1QgKiBGUk9NIEZOX0FSQk9MKCk7DQogDQpFbCBwcnBvYmxlbWEgZXMgcXVlIG5vIG1lIHRyYWUg
bmluZ3VuIHJlZ2lzdHJvIHBlc2UgYSBxdWUgbGEgdGJsYSB0ZW1wb3JhbCBzaSBjb250aWVuZSBs
b3MgcmVnaXN0cm9zLCDCv25vIHNlIHNpIGVzdG95IHV0aWxpemFuZG8gY29ycmVjdGFtZW50ZSBl
bCBSRVRVUk4gTkVYVD8NCiANCmJ1ZW5vIGNvbW8gZGlqZSBhbnRlcyBhZ3JhZGVjZXNjbyBjdWFs
cXVpZXIgYXl1ZGENCg==