X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E3A64D1B433 for ; Mon, 15 Dec 2003 17:17:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 78696-08 for ; Mon, 15 Dec 2003 13:16:47 -0400 (AST) Received: from ss009.bos.hosting.com (unknown [64.55.205.106]) by svr1.postgresql.org (Postfix) with ESMTP id 3BA2ED1B4C8 for ; Mon, 15 Dec 2003 13:16:40 -0400 (AST) Received: from webdev04 ([65.107.119.233]) by ss009.bos.hosting.com (8.12.9/8.12.9) with SMTP id hBFHGYmO021263 for ; Mon, 15 Dec 2003 12:16:44 -0500 (EST) Reply-To: From: "Prashant Dalal" To: Subject: NOT-IN CLAUSE Date: Mon, 15 Dec 2003 12:14:17 -0500 Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_000E_01C3C304.F8774F40" X-Priority: 1 (Highest) X-MSMail-Priority: High X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) Importance: High X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-MS-TNEF-Correlator: X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=3.6 tagged_above=0.0 required=5.0 tests=MSGID_GOOD_EXCHANGE, RCVD_IN_OSIRUSOFT_COM, SUBJ_ALL_CAPS, X_MSMAIL_PRIORITY_HIGH, X_PRIORITY_HIGH X-Spam-Level: *** X-Archive-Number: 200312/107 X-Sequence-Number: 16273 This is a multi-part message in MIME format. ------=_NextPart_000_000E_01C3C304.F8774F40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi, My Following select st. is running from last one day. I think the problem is NOT IN clause. Please suggest the alternative select clause. SELECT resreq.proj, resreq.ver, substr(resreq.act, -5, 5) act, resreq.rn, null, null, resreq.rl, resreq.dr, resreq.ra FROM resreq WHERE resreq.ver IN ('0', '99') AND NOT (resreq.proj, resreq.ver, substr(resreq.act, -5, 5), resreq.rn) IN (SELECT actres.proj, actres.ver, substr(actres.act, -5, 5) act, actres.rn FROM actres, resreq WHERE actres.proj = resreq.proj AND actres.ver = resreq.ver AND substr(actres.act, -5, 5) = substr(resreq.act, -5, 5) AND actres.rn = resreq.rn AND actres.ver IN ('0', '99')) Best Regards, Prashant Dalal. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ LaborLogix ------=_NextPart_000_000E_01C3C304.F8774F40 Content-Type: application/ms-tnef; name="winmail.dat" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="winmail.dat" eJ8+IhQRAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcA GAAAAElQTS5NaWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAQABAAEG gAMADgAAANMHDAAPAAwADQAAAAEADwEBA5AGABAGAAAiAAAACwACAAEAAAAL ACMAAAAAAAMAJgABAAAACwApAAAAAAADADYAAAAAAB4AcAABAAAADgAAAE5P VC1JTiBDTEFVU0UAAAACAXEAAQAAABYAAAABw8MuyEFAhrE8ATVPX4OGdEfu 6WqjAAACAR0MAQAAABsAAABTTVRQOlBEQUxBTEBMQUJPUkxPR0lYLkNPTQAA CwABDgAAAABAAAYOALbhsC7DwwECAQoOAQAAABgAAAAAAAAAsmq4+4r71BGq pwCQJ8xNMcKAAAALAB8OAQAAAAIBCRABAAAAcwIAAG8CAABPBQAATFpGdarD G2oDAAoAcmNwZzEyNRYyAPgLYG4OEDAzM08B9wKkBGQCAGNoCsBz8GV0MCAI VQeyAoMAUP8DVBDZB20Cgw5QA9QQ3xHlZn0KgAjIIDsJbw4gOPUX32UOMDUZ KhjxCiQCgCUKgXYIkHdrC4BkNB0MYGMAUAsDC7UgSGkOLAqiCoQKgE15IEav BvAJAAPwDyAgFdBsBZAhBUBzdC4gBAAgctx1bgMAH1EDUiALYB/wgiACIGUg ZGF5IBDQSSB0aAuAayIhIaA2cANgAmBlIRAgMU5PolQiAE4gYwtgdRXQOi4d 9FAfoCFAIaBzdbxnZweQBUAikgdAdASR8GF0aXYlER+UI/snn8AKU0VMRUMj oAlwknMJcHEuItFqLCl2LSaAciowJTBiH/ByKEsphQDQdCowLTUqMDU+KSXg LAIphQSgKjBudfcfACowHfQgLnQttC0GLxgWZCrhLQZhLhhGUk8GTSl1LhhX SEVSRUMqSSOyKCcwJyowJxA5OScpLhpBTkT/I3Mrdin/Kw8sFyzpNQsucv80 MikVK/E2YTbFO/U3qjv1/yv/Ok5AKjv1ELE/jzGmO/TPNxZBzzLoO/kgPSl6 RE//NXg8yEaoN6FHjzV4PY8sJ/9GsDf/LCZKr0ifBKFGt0Gvv1CfSYQ0PDUF Vf9WpmMAQMQgQiVyUmVnCxFDsNMd9QwxIFAxEHMVoAIwXCBEB0AHQCRQbAuA ZTtX0Q5QaQLREoEL8DQgnn5b71yYWpQLA3NiD0DJAUBzYV5xIEwBoAWwhVfR M18Ab2dpeFfSfwogAUBaoxTjDAEeAxbxAAFh4AALAACACCAGAAAAAADAAAAA AAAARgAAAAADhQAAAAAAAAMAAoAIIAYAAAAAAMAAAAAAAABGAAAAABCFAAAA AAAAAwAHgAggBgAAAAAAwAAAAAAAAEYAAAAAUoUAAHN5AQAeAAmACCAGAAAA AADAAAAAAAAARgAAAABUhQAAAQAAAAQAAAA5LjAACwANgAggBgAAAAAAwAAA AAAAAEYAAAAAgoUAAAEAAAALABGACCAGAAAAAADAAAAAAAAARgAAAAAGhQAA AAAAAAMAEoAIIAYAAAAAAMAAAAAAAABGAAAAAAGFAAAAAAAACwAbgAggBgAA AAAAwAAAAAAAAEYAAAAADoUAAAAAAAADAByACCAGAAAAAADAAAAAAAAARgAA AAARhQAAAAAAAAMAHoAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAAAgH4 DwEAAAAQAAAAsmq4+4r71BGqpwCQJ8xNMQIB+g8BAAAAEAAAALJquPuK+9QR qqcAkCfMTTECAfsPAQAAAEgAAAAAAAAAOKG7EAXlEBqhuwgAKypWwgAAUFNU UFJYLkRMTAAAAAAAAAAATklUQfm/uAEAqgA32W4AAABFOlxtYWlsYm94LnBz dAADAP4PBQAAAAMADTT9NwAAAgF/AAEAAAA1AAAAPE5FQkJLS0tITENQS0pQ REhNSE1LQ0VFRExFQUIucGRhbGFsQGxhYm9ybG9naXguY29tPgAAAAADAAYQ 5QGtwwMABxAsAgAAAwAQEAAAAAADABEQAAAAAB4ACBABAAAAZQAAAEhJLE1Z Rk9MTE9XSU5HU0VMRUNUU1RJU1JVTk5JTkdGUk9NTEFTVE9ORURBWUlUSElO S1RIRVBST0JMRU1JU05PVElOQ0xBVVNFUExFQVNFU1VHR0VTVFRIRUFMVEVS TkFUSVYAAAAAv2Y= ------=_NextPart_000_000E_01C3C304.F8774F40--