X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D739AD1B209 for ; Fri, 23 Jul 2004 09:50:37 -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 08611-10 for ; Fri, 23 Jul 2004 12:50:43 +0000 (GMT) Received: from jais.jouy.inra.fr (jais.jouy.inra.fr [138.102.1.17]) by svr1.postgresql.org (Postfix) with ESMTP id 49EEFD1B1D5 for ; Fri, 23 Jul 2004 09:50:33 -0300 (ADT) Received: from diamant.jouy.inra.fr (localhost [127.0.0.1]) by jais.jouy.inra.fr (8.10.1/8.10.1) with ESMTP id i6NCodN14437 for ; Fri, 23 Jul 2004 14:50:39 +0200 (CEST) Received: from pc502jlo (pc502ljo [138.102.3.71]) by diamant.jouy.inra.fr (8.10.1/8.10.1) with SMTP id i6NCodU06081 for ; Fri, 23 Jul 2004 14:50:39 +0200 (CEST) Message-ID: <006d01c470b3$aa0381f0$4703668a@pc502jlo> From: "Jouneau Luc" To: Subject: Seq scan with a like operator Date: Fri, 23 Jul 2004 14:50:42 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_006A_01C470C4.6D5C8F60" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.3 tagged_above=0.0 required=5.0 tests=FORGED_OUTLOOK_TAGS, MIME_BASE64_LATIN, MIME_BASE64_TEXT X-Spam-Level: *** X-Archive-Number: 200407/268 X-Sequence-Number: 14336 This is a multi-part message in MIME format. ------=_NextPart_000_006A_01C470C4.6D5C8F60 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: base64 SGksDQpJIGRvbid0IHVuZGVyc3RhbmQgd2h5IHdpdGggYSBsaWtlIG9wZXJh dG9yLCBQb3N0Z3JlU1FMIDcuNC4yIGRvZXMgbm90IGJlaGF2ZSB0aGUgc2Ft ZSBhcyB3aXRoIGFuIGVxdWFsIG9wZXJhdG9yIDogDQoNCkhlcmUncyBhIHRh YmxlIHdpdGggYWJvdXQgMjAwLjAwMCB0dXBsZXMgOiANCkNSRUFURSBUQUJM RSBwdWJsaWMuYW5udV9wZXJzMg0KKA0KICBub20gdmFyY2hhcig1MCksDQog IHByZW5vbSB2YXJjaGFyKDUwKSwNCiAgbm9tX2ludCB2YXJjaGFyKDUwKSwN CiAgLi4uLg0KKSBXSVRIIE9JRFM7DQoNCkNSRUFURSBJTkRFWCBwZXJzb25u ZV9mazMNCiAgT04gcHVibGljLmFubnVfcGVyczINCiAgVVNJTkcgYnRyZWUN CiAgKG5vbV9pbnQpOw0KDQo9PT09PT0NCkhlcmUgYXJlIHRoZSB0d28gZXhw bGFpbiBhbmFseXplIHJlcXVlc3RzIDoNCnNlbGVjdCBub21faW50DQpmcm9t IGFubnVfcGVyczIgDQp3aGVyZSBub21faW50ID0nWCcNCg0KSW5kZXggU2Nh biB1c2luZyBwZXJzb25uZV9mazMgb24gYW5udV9wZXJzMiAgKGNvc3Q9MC4w MC4uMTI1LjY2IHJvd3M9MzEgd2lkdGg9MTEpIChhY3R1YWwgdGltZT0wLjM1 OS4uMC4zNTkgcm93cz0wIGxvb3BzPTEpDQogIEluZGV4IENvbmQ6ICgobm9t X2ludCk6OnRleHQgPSAnWCc6OnRleHQpDQpUb3RhbCBydW50aW1lOiAwLjQ5 MCBtcw0KLS0tLS0tLQ0Kc2VsZWN0IG5vbV9pbnQNCmZyb20gYW5udV9wZXJz MiANCndoZXJlIG5vbV9pbnQgbGlrZSAnWCcNCg0KU2VxIFNjYW4gb24gYW5u dV9wZXJzMiAgKGNvc3Q9MC4wMC4uNTg4NS42MCByb3dzPTMxIHdpZHRoPTEx KSAoYWN0dWFsIHRpbWU9MTIxMy41OTQuLjEyMTMuNTk0IHJvd3M9MCBsb29w cz0xKQ0KICBGaWx0ZXI6ICgobm9tX2ludCk6OnRleHQgfn4gJ1gnOjp0ZXh0 KQ0KVG90YWwgcnVudGltZTogMTIxMy43MjkgbXMNCg0KQ291bGQgc29tZW9u ZSBnaXZlIG1lIGEgcmVhc29uIG9mIHRoZSBzZXF1ZW50aWFsIHNjYW4gb24g dGhlIHJlcXVlc3Qgd2l0aCBsaWtlIG9wZXJhdG9yDQooSSBrbm93IHRoYXQg d2l0aG91dCAlIGEgbGlrZSBvcGVyYXRvciBpcyBub3QgdXNlZnVsbCwgYnV0 IGl0IHdhcyB0byByZXN0cmFpbiBhcyBtdWNoIGFzIHBvc3NpYmxlIHByb2Jh YmlsaXR5IG9mIG1pc3Rha2VzIC0gdGhlIHByb2JsZW0gcmVtYWlucyB0aGUg c2FtZSB3aXRoIG9yIHdpdGhvdXQgJSkuDQoNClRoYW5rcyBmb3IgeW91ciBh bnN3ZXIocykuDQoNCkx1Yw== ------=_NextPart_000_006A_01C470C4.6D5C8F60 Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: base64 PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBU cmFuc2l0aW9uYWwvL0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgaHR0cC1l cXVpdj1Db250ZW50LVR5cGUgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0 PXdpbmRvd3MtMTI1MiI+PEJBU0UgDQpocmVmPSJmaWxlOi8vQzpcUHJvZ3Jh bSBGaWxlc1xGaWNoaWVycyBjb21tdW5zXE1pY3Jvc29mdCBTaGFyZWRcUGFw aWVyIOAgbGV0dHJlc1wiPg0KPFNUWUxFPkJPRFkgew0KCUJBQ0tHUk9VTkQt UE9TSVRJT046IGxlZnQgdG9wOyBGT05ULVNJWkU6IDEwcHQ7IENPTE9SOiAj MDAwMDAwOyBCQUNLR1JPVU5ELVJFUEVBVDogbm8tcmVwZWF0OyBGT05ULUZB TUlMWTogQXJpYWwNCn0NCjwvU1RZTEU+DQoNCjxNRVRBIGNvbnRlbnQ9Ik1T SFRNTCA2LjAwLjI4MDAuMTQwMCIgbmFtZT1HRU5FUkFUT1I+PC9IRUFEPg0K PEJPRFkgYmdDb2xvcj0jYzBjMGMwPg0KPERJVj5IaSw8L0RJVj4NCjxESVY+ SSBkb24ndCB1bmRlcnN0YW5kIHdoeSB3aXRoIGEgbGlrZSBvcGVyYXRvciwg UG9zdGdyZVNRTCA3LjQuMiBkb2VzIG5vdCANCmJlaGF2ZSB0aGUgc2FtZSBh cyB3aXRoIGFuIGVxdWFsIG9wZXJhdG9yIDogPC9ESVY+DQo8RElWPiZuYnNw OzwvRElWPg0KPERJVj5IZXJlJ3MgYSB0YWJsZSB3aXRoIGFib3V0IDIwMC4w MDAgdHVwbGVzIDogPC9ESVY+DQo8RElWPkNSRUFURSBUQUJMRSBwdWJsaWMu YW5udV9wZXJzMjxCUj4oPEJSPiZuYnNwOyBub20gdmFyY2hhcig1MCksPEJS PiZuYnNwOyANCnByZW5vbSB2YXJjaGFyKDUwKSw8QlI+Jm5ic3A7IG5vbV9p bnQgdmFyY2hhcig1MCksPEJSPiZuYnNwOyZuYnNwOy4uLi48L0RJVj4NCjxE SVY+KSBXSVRIIE9JRFM7PEJSPjwvRElWPg0KPERJVj5DUkVBVEUgSU5ERVgg cGVyc29ubmVfZmszPEJSPiZuYnNwOyBPTiBwdWJsaWMuYW5udV9wZXJzMjxC Uj4mbmJzcDsgVVNJTkcgDQpidHJlZTxCUj4mbmJzcDsgKG5vbV9pbnQpOzxC Uj48L0RJVj4NCjxESVY+PT09PT09PC9ESVY+DQo8RElWPkhlcmUgYXJlIHRo ZSB0d28gZXhwbGFpbiBhbmFseXplIHJlcXVlc3RzIDo8L0RJVj4NCjxESVY+ c2VsZWN0IG5vbV9pbnQ8QlI+ZnJvbSBhbm51X3BlcnMyIDxCUj53aGVyZSBu b21faW50ID0nWCc8L0RJVj4NCjxESVY+Jm5ic3A7PC9ESVY+DQo8RElWPklu ZGV4IFNjYW4gdXNpbmcgcGVyc29ubmVfZmszIG9uIGFubnVfcGVyczImbmJz cDsgKGNvc3Q9MC4wMC4uMTI1LjY2IA0Kcm93cz0zMSB3aWR0aD0xMSkgKGFj dHVhbCB0aW1lPTAuMzU5Li4wLjM1OSByb3dzPTAgbG9vcHM9MSk8QlI+Jm5i c3A7IEluZGV4IA0KQ29uZDogKChub21faW50KTo6dGV4dCA9ICdYJzo6dGV4 dCk8QlI+VG90YWwgcnVudGltZTogMC40OTAgbXM8L0RJVj4NCjxESVY+LS0t LS0tLTwvRElWPg0KPERJVj5zZWxlY3Qgbm9tX2ludDxCUj5mcm9tIGFubnVf cGVyczIgPEJSPndoZXJlIG5vbV9pbnQgbGlrZSAnWCc8L0RJVj4NCjxESVY+ Jm5ic3A7PC9ESVY+DQo8RElWPlNlcSBTY2FuIG9uIGFubnVfcGVyczImbmJz cDsgKGNvc3Q9MC4wMC4uNTg4NS42MCByb3dzPTMxIHdpZHRoPTExKSAoYWN0 dWFsIA0KdGltZT0xMjEzLjU5NC4uMTIxMy41OTQgcm93cz0wIGxvb3BzPTEp PEJSPiZuYnNwOyBGaWx0ZXI6ICgobm9tX2ludCk6OnRleHQgfn4gDQonWCc6 OnRleHQpPEJSPlRvdGFsIHJ1bnRpbWU6IDEyMTMuNzI5IG1zPC9ESVY+DQo8 RElWPiZuYnNwOzwvRElWPg0KPERJVj5Db3VsZCBzb21lb25lIGdpdmUgbWUg YSByZWFzb24gb2YgdGhlIHNlcXVlbnRpYWwgc2NhbiBvbiB0aGUgcmVxdWVz dCB3aXRoIA0KbGlrZSBvcGVyYXRvcjwvRElWPg0KPERJVj4oSSBrbm93IHRo YXQgd2l0aG91dCAlIGEgbGlrZSBvcGVyYXRvciBpcyBub3QgdXNlZnVsbCwg YnV0IGl0IHdhcyB0byANCnJlc3RyYWluIGFzIG11Y2ggYXMgcG9zc2libGUg cHJvYmFiaWxpdHkgb2YgbWlzdGFrZXMgLSB0aGUgcHJvYmxlbSByZW1haW5z IHRoZSANCnNhbWUgd2l0aCBvciB3aXRob3V0ICUpLjwvRElWPg0KPERJVj4m bmJzcDs8L0RJVj4NCjxESVY+VGhhbmtzIGZvciB5b3VyIGFuc3dlcihzKS48 L0RJVj4NCjxESVY+Jm5ic3A7PC9ESVY+DQo8RElWPkx1YzwvRElWPjwvQk9E WT48L0hUTUw+DQo= ------=_NextPart_000_006A_01C470C4.6D5C8F60--