X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 863B3D93A8 for ; Mon, 19 Sep 2005 14:29:49 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 28710-10 for ; Mon, 19 Sep 2005 17:29:41 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.202]) by svr1.postgresql.org (Postfix) with ESMTP id BD485D6F17 for ; Mon, 19 Sep 2005 14:29:40 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id z31so3820nzd for ; Mon, 19 Sep 2005 10:29:40 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=rJVUPs+LUUUyB8PSkfkPK1kER1nctItIu9K3ZBUulCA7XjZXI+xIE2dhy0KqQdz830p+fJi/W/SaMR9Ob7jDmJaWlAY8XLpRFbjGWT13k246y1sJmwRrZZJiKGtCsvzg1IlqrSwFMNFARqWi4bIDeFlYZl8og4I3yzAHmITn47I= Received: by 10.54.46.30 with SMTP id t30mr1186173wrt; Mon, 19 Sep 2005 10:29:40 -0700 (PDT) Received: by 10.54.80.9 with HTTP; Mon, 19 Sep 2005 10:29:40 -0700 (PDT) Message-ID: <32c009ea050919102924653bfa@mail.gmail.com> Date: Mon, 19 Sep 2005 20:29:40 +0300 From: "Milen A. Radev" Reply-To: milen@radev.net To: pgsql-sql@postgresql.org Subject: Difficulties with a master-detail query Mime-Version: 1.0 Content-Type: text/plain; charset=KOI8-R Content-Transfer-Encoding: base64 Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.317 required=5 tests=[AWL=-0.088, RCVD_BY_IP=0.024, SEE_FOR_YOURSELF=0.381] X-Spam-Level: X-Archive-Number: 200509/222 X-Sequence-Number: 22769 SGksIGxpc3QhCgpZb3UgaGF2ZSBtb3N0IHByb2JhYmx5IG1ldCB0aGUgc2FtZSBwcm9ibGVtOgoK SSBoYXZlIGEgbWFzdGVyIHRhYmxlLCBkZXNjcmliaW5nIHRoZSBvYmplY3MgSSdtIGludGVyZXN0 ZWQgaW4gLSBsZXQncwpzYXkgZW1wbG95ZWVzLiBJIGhhdmUgYSBkZXRhaWxzIHRhYmxlLCBkZWZp bmluZyBhbGwgcG9zc2libGUgdmFsdWVzIG9mCm9uZSBvZiB0aGUgcHJvcGVydGllcyBvZiB0aGUg b2JqZWN0cyAtIGxldCdzIHNheSBsYW5ndWFnZXMgc3Bva2VuLiBBbmQKb2YgY291cnNlIEkgaGF2 ZSBhIHRhYmxlIGRlc3JpYmluZyB0aGUgdGFibGUgdGhlIGNvbm5lY3Rpb24gYmV0d2Vlbgp0aGUg bGF0dGVyIHR3byAtIE46TiAoZmFpcmx5IHN0YW5kYXJkIHNvbHV0aW9uKS4KCkhlcmUgaXMgdGhl IHNjaGVtZToKCkNSRUFURSBUQUJMRSBlbXBsb3llZSAoCiAgZW1wbG95ZWVfaWQgc2VyaWFsIFBS SU1BUlkgS0VZLAogIG5hbWUgdmFyY2hhcigyMCkKKTsKCkNSRUFURSBUQUJMRSBza2lsbCAoCiAg c2tpbGxfaWQgc2VyaWFsIFBSSU1BUlkgS0VZLAogIG5hbWUgdmFyY2hhcigyMCkKKTsKCkNSRUFU RSBUQUJMRSBlbXBsb3llZV9za2lsbCAoCiAgZW1wbG95ZWVfaWQgaW50ZWdlciwKICBza2lsbF9p ZCBpbnRlZ2VyLAogIENPTlNUUkFJTlQgZW1wbG95ZWVfc2tpbGxfZW1wbG95ZWVfaWRfZmtleSBG T1JFSUdOIEtFWSAoZW1wbG95ZWVfaWQpClJFRkVSRU5DRVMgZW1wbG95ZWUoZW1wbG95ZWVfaWQp LAogIENPTlNUUkFJTlQgZW1wbG95ZWVfc2tpbGxfc2tpbGxfaWRfZmtleSBGT1JFSUdOIEtFWSAo c2tpbGxfaWQpClJFRkVSRU5DRVMgc2tpbGwgKHNraWxsX2lkKSwKICBDT05TVFJBSU5UIGVtcGxv eWVlX3NraWxsX2VtcGxveWVlX2lkX2tleSBVTklRVUUgKGVtcGxveWVlX2lkLCBza2lsbF9pZCkK KTsKCgpJIHdvdWxkIGxpa2UgdG8gZ2V0IGFsbCBlbXBsb3llZXMsIHdobyBzcGVhayB0d28gc3Bl Y2lmaWVkIGxhbmd1YWdlcwooc2F5IGdlcm1hbiBhbmQgZnJlbmNoKS4gVGhlIGZvbGxvd2luZyBx dWVyeSBnaXZlcyBtZSB0aGF0LCBidSBJIGRvbid0Cmxpa2UgaXQgKHNlZSBmb3IgeW91cnNlbGYp OgoKClNFTEVDVAogIMUuZW1wbG95ZWVfaWQsCiAgxS5uYW1lLAogIENPVU5UKHMuc2tpbGxfaWQp CkZST00KICBlbXBsb3llZSBBUyBlCklOTkVSIEpPSU4KICBlbXBsb3llZV9za2lsbCBBUyBlcwpP TgogIGUuZW1wbG95ZWVfaWQ9ZXMuZW1wbG95ZWVfaWQKSU5ORVIgSk9JTgogIHNraWxsIEFTIHMK T04KICBzLnNraWxsX2lkPWVzLnNraWxsX2lkIEFORCBzLnNraWxsX2lkIElOICgxLCAyKQpHUk9V UCBCWQogIGUuZW1wbG95ZWVfaWQsCiAgZS5uYW1lCkhBVklORwogIENPVU5UKHMuc2tpbGxfaWQp Pj0yOwoKCkhlcmUgIigxLCAyKSIgYXJlIHRoZSBJRHMgZm9yIHRob3NlIHByZWRlZmluZWQgdHdv IGxhbmd1YWdlcywgZ290IGZyb20KdGhlICJza2lsbCIgdGFibGUuIOFuZCB0aGF0IHR3byBpbiAi Q09VTlQocy5za2lsbF9pZCk+PTIiIGlzIHRoZXJlCmJlY2F1c2UgdGhlIGNvdW50IG9mIHRoZSBs YW5ndWFnZXMuCgoKQW55IGlkZWFzIGZvciBzaW1wbGVyIGFuZCBtb3JlIHVuaXZlcnNhbCBxdWVy eT8KCgpQbGVhc2UgQ0MgbWUsIGJlY2F1c2UgSSdtIG5vdCBzdWJzY3JpYmVkLgoKLS0gCk1pbGVu IEEuIFJhZGV2Cg==