Received: from srvlnx02.pup.ch (zg-d-187.agrinet.ch [212.28.131.187]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0NEeG064537 for ; Tue, 23 Jan 2001 09:40:17 -0500 (EST) (envelope-from juerg.rietmann@pup.ch) Subject: monster query, how to make it smaller To: pgsql-sql@postgresql.org X-Mailer: Lotus Notes Release 5.0.5 September 22, 2000 Message-ID: From: juerg.rietmann@pup.ch Date: Tue, 23 Jan 2001 15:42:10 +0100 X-MIMETrack: Serialize by Router on srvlnx02/Pup/ch(Release 5.0.5 |September 22, 2000) at 01/23/2001 03:42:43 PM MIME-Version: 1.0 Content-type: multipart/mixed; Boundary="0__=C12569DD00504C908f9e8a93df938690918cC12569DD00504C90" Content-Disposition: inline X-Archive-Number: 200101/291 X-Sequence-Number: 960 --0__=C12569DD00504C908f9e8a93df938690918cC12569DD00504C90 Content-type: text/plain; charset=us-ascii Hello everybody I need some help on a monster query. Please see the attached file for the query itself. The only difference is Z_durch_soll and the offset, which is currently 0.25. The query will run in a loop where I increment this offset until I find enough records. Thanks in advance ... jr (See attached file: monsterQuery.txt) ============================================ PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland phone: +4141 790 4040 fax: +4141 790 2545 mobile: +4179 211 0315 ============================================ --0__=C12569DD00504C908f9e8a93df938690918cC12569DD00504C90 Content-type: application/octet-stream; name="monsterQuery.txt" Content-Disposition: attachment; filename="monsterQuery.txt" Content-transfer-encoding: base64 c2VsZWN0IFpfZHVyY2hfc29sbCwgWl9pZCwgWl9zdGF0dXMsIFpfZHVyY2hf aXN0LCAoKChaX2R1cmNoX3NvbGwrMC4yNSktWl9kdXJjaF9pc3QpIC8gMikg QVMgWl9kdXJjaF9kZWx0YSwgWl9kdXJjaF9zb2xsKzAuMjUgQVMgWl9kdXJj aF9rb3JyDQpmcm9tIFp5bGluZGVyDQp3aGVyZSAoWl9BX25yIGlzIE5VTEwN CkFORCBaX3VtZmFuZyA9ICc5MDAnIEFORCBaX2JsYWVuZ2UgPSAnMjM0MCcg QU5EIFpfZHVyY2hfc29sbCA9JzI4Ni40NScNCkFORCBaX3N0YXR1cyA9ICd6 Y3UnDQpBTkQgKCgoWl9kdXJjaF9zb2xsKzAuMjUpLVpfZHVyY2hfaXN0KSAv IDIpID49IDAuMDg1DQpBTkQgKCgoWl9kdXJjaF9zb2xsKzAuMjUpLVpfZHVy Y2hfaXN0KSAvIDIpID4gIDAuMTIpDQpVTklPTg0Kc2VsZWN0IFpfZHVyY2hf c29sbCwgWl9pZCwgWl9zdGF0dXMsIFpfZHVyY2hfaXN0LCAoKChaX2R1cmNo X3NvbGwrMC4yKS1aX2R1cmNoX2lzdCkgLyAyKSBBUyBaX2R1cmNoX2RlbHRh LCBaX2R1cmNoX3NvbGwrMC4yIEFTIFpfZHVyY2hfa29ycg0KZnJvbSBaeWxp bmRlcg0Kd2hlcmUgKFpfQV9uciBpcyBOVUxMDQpBTkQgWl91bWZhbmcgPSAn OTAwJyBBTkQgWl9ibGFlbmdlID0gJzIzNDAnIEFORCBaX2R1cmNoX3NvbGwg PScyODYuNDAnDQpBTkQgWl9zdGF0dXMgPSAnemN1Jw0KQU5EICgoKFpfZHVy Y2hfc29sbCswLjI1KS1aX2R1cmNoX2lzdCkgLyAyKSA+PSAwLjA4NQ0KQU5E ICgoKFpfZHVyY2hfc29sbCswLjI1KS1aX2R1cmNoX2lzdCkgLyAyKSA+ICAw LjEyKQ0KVU5JT04NCnNlbGVjdCBaX2R1cmNoX3NvbGwsIFpfaWQsIFpfc3Rh dHVzLCBaX2R1cmNoX2lzdCwgKCgoWl9kdXJjaF9zb2xsKzAuMiktWl9kdXJj aF9pc3QpIC8gMikgQVMgWl9kdXJjaF9kZWx0YSwgWl9kdXJjaF9zb2xsKzAu MiBBUyBaX2R1cmNoX2tvcnINCmZyb20gWnlsaW5kZXINCndoZXJlIChaX0Ff bnIgaXMgTlVMTA0KQU5EIFpfdW1mYW5nID0gJzkwMCcgQU5EIFpfYmxhZW5n ZSA9ICcyMzQwJyBBTkQgWl9kdXJjaF9zb2xsID0nMjg2LjM1Jw0KQU5EIFpf c3RhdHVzID0gJ3pjdScNCkFORCAoKChaX2R1cmNoX3NvbGwrMC4yNSktWl9k dXJjaF9pc3QpIC8gMikgPj0gMC4wODUNCkFORCAoKChaX2R1cmNoX3NvbGwr MC4yNSktWl9kdXJjaF9pc3QpIC8gMikgPiAgMC4xMikNClVOSU9ODQpzZWxl Y3QgWl9kdXJjaF9zb2xsLCBaX2lkLCBaX3N0YXR1cywgWl9kdXJjaF9pc3Qs ICgoKFpfZHVyY2hfc29sbCswLjIpLVpfZHVyY2hfaXN0KSAvIDIpIEFTIFpf ZHVyY2hfZGVsdGEsIFpfZHVyY2hfc29sbCswLjIgQVMgWl9kdXJjaF9rb3Jy DQpmcm9tIFp5bGluZGVyDQp3aGVyZSAoWl9BX25yIGlzIE5VTEwNCkFORCBa X3VtZmFuZyA9ICc5MDAnIEFORCBaX2JsYWVuZ2UgPSAnMjM0MCcgQU5EIFpf ZHVyY2hfc29sbCA9JzI4Ni4zMCcNCkFORCBaX3N0YXR1cyA9ICd6Y3UnDQpB TkQgKCgoWl9kdXJjaF9zb2xsKzAuMjUpLVpfZHVyY2hfaXN0KSAvIDIpID49 IDAuMDg1DQpBTkQgKCgoWl9kdXJjaF9zb2xsKzAuMjUpLVpfZHVyY2hfaXN0 KSAvIDIpID4gIDAuMTIpDQpVTklPTg0Kc2VsZWN0IFpfZHVyY2hfc29sbCwg Wl9pZCwgWl9zdGF0dXMsIFpfZHVyY2hfaXN0LCAoKChaX2R1cmNoX3NvbGwr MC4yKS1aX2R1cmNoX2lzdCkgLyAyKSBBUyBaX2R1cmNoX2RlbHRhLCBaX2R1 cmNoX3NvbGwrMC4yIEFTIFpfZHVyY2hfa29ycg0KZnJvbSBaeWxpbmRlcg0K d2hlcmUgKFpfQV9uciBpcyBOVUxMDQpBTkQgWl91bWZhbmcgPSAnOTAwJyBB TkQgWl9ibGFlbmdlID0gJzIzNDAnIEFORCBaX2R1cmNoX3NvbGwgPScyODYu MjAnDQpBTkQgWl9zdGF0dXMgPSAnemN1Jw0KQU5EICgoKFpfZHVyY2hfc29s bCswLjI1KS1aX2R1cmNoX2lzdCkgLyAyKSA+PSAwLjA4NQ0KQU5EICgoKFpf ZHVyY2hfc29sbCswLjI1KS1aX2R1cmNoX2lzdCkgLyAyKSA+ICAwLjEyKQ0K VU5JT04NCnNlbGVjdCBaX2R1cmNoX3NvbGwsIFpfaWQsIFpfc3RhdHVzLCBa X2R1cmNoX2lzdCwgKCgoWl9kdXJjaF9zb2xsKzAuMiktWl9kdXJjaF9pc3Qp IC8gMikgQVMgWl9kdXJjaF9kZWx0YSwgWl9kdXJjaF9zb2xsKzAuMiBBUyBa X2R1cmNoX2tvcnINCmZyb20gWnlsaW5kZXINCndoZXJlIChaX0FfbnIgaXMg TlVMTA0KQU5EIFpfdW1mYW5nID0gJzkwMCcgQU5EIFpfYmxhZW5nZSA9ICcy MzQwJyBBTkQgWl9kdXJjaF9zb2xsID0nMjg2LjE1Jw0KQU5EIFpfc3RhdHVz ID0gJ3pjdScNCkFORCAoKChaX2R1cmNoX3NvbGwrMC4yNSktWl9kdXJjaF9p c3QpIC8gMikgPj0gMC4wODUNCkFORCAoKChaX2R1cmNoX3NvbGwrMC4yNSkt Wl9kdXJjaF9pc3QpIC8gMikgPiAgMC4xMikNClVOSU9ODQpzZWxlY3QgWl9k dXJjaF9zb2xsLCBaX2lkLCBaX3N0YXR1cywgWl9kdXJjaF9pc3QsICgoKFpf ZHVyY2hfc29sbCswLjIpLVpfZHVyY2hfaXN0KSAvIDIpIEFTIFpfZHVyY2hf ZGVsdGEsIFpfZHVyY2hfc29sbCswLjIgQVMgWl9kdXJjaF9rb3JyDQpmcm9t IFp5bGluZGVyDQp3aGVyZSAoWl9BX25yIGlzIE5VTEwNCkFORCBaX3VtZmFu ZyA9ICc5MDAnIEFORCBaX2JsYWVuZ2UgPSAnMjM0MCcgQU5EIFpfZHVyY2hf c29sbCA9JzI4Ni4xJw0KQU5EIFpfc3RhdHVzID0gJ3pjdScNCkFORCAoKCha X2R1cmNoX3NvbGwrMC4yNSktWl9kdXJjaF9pc3QpIC8gMikgPj0gMC4wODUN CkFORCAoKChaX2R1cmNoX3NvbGwrMC4yNSktWl9kdXJjaF9pc3QpIC8gMikg PiAgMC4xMikNClVOSU9ODQpzZWxlY3QgWl9kdXJjaF9zb2xsLCBaX2lkLCBa X3N0YXR1cywgWl9kdXJjaF9pc3QsICgoKFpfZHVyY2hfc29sbCswLjIpLVpf ZHVyY2hfaXN0KSAvIDIpIEFTIFpfZHVyY2hfZGVsdGEsIFpfZHVyY2hfc29s bCswLjIgQVMgWl9kdXJjaF9rb3JyDQpmcm9tIFp5bGluZGVyDQp3aGVyZSAo Wl9BX25yIGlzIE5VTEwNCkFORCBaX3VtZmFuZyA9ICc5MDAnIEFORCBaX2Js YWVuZ2UgPSAnMjM0MCcgQU5EIFpfZHVyY2hfc29sbCA9JzI4Ni4wNScNCkFO RCBaX3N0YXR1cyA9ICd6Y3UnDQpBTkQgKCgoWl9kdXJjaF9zb2xsKzAuMjUp LVpfZHVyY2hfaXN0KSAvIDIpID49IDAuMDg1DQpBTkQgKCgoWl9kdXJjaF9z b2xsKzAuMjUpLVpfZHVyY2hfaXN0KSAvIDIpID4gIDAuMTIpDQpvcmRlciBi eSBaX2R1cmNoX3NvbGwgREVTQywgWl9kdXJjaF9kZWx0YSBBU0M= --0__=C12569DD00504C908f9e8a93df938690918cC12569DD00504C90--