X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E02E15E46F1 for ; Sun, 15 Aug 2004 16:18:15 -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 75553-08 for ; Sun, 15 Aug 2004 19:18:10 +0000 (GMT) Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.173]) by svr1.postgresql.org (Postfix) with ESMTP id 087925E46EF for ; Sun, 15 Aug 2004 16:18:08 -0300 (ADT) Received: from [212.227.126.207] (helo=mrelayng.kundenserver.de) by moutng.kundenserver.de with esmtp (Exim 3.35 #1) id 1BwQW3-0008Lc-00; Sun, 15 Aug 2004 21:18:03 +0200 Received: from [80.146.135.17] (helo=lorien.finner.de) by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1) id 1BwQW2-00071w-00; Sun, 15 Aug 2004 21:18:03 +0200 Received: from isengard.finner.de (isengard.finner.de [192.168.14.20]) by lorien.finner.de (Invenius Mailomatics) with ESMTP id EA59A56EB4; Sun, 15 Aug 2004 21:17:52 +0200 (CEST) Received: by isengard.finner.de (Postfix, from userid 500) id 0C4A38855C; Sun, 15 Aug 2004 21:17:49 +0200 (CEST) Date: Sun, 15 Aug 2004 21:17:49 +0200 From: Frank Finner To: "Traci Sumpter" Cc: pgsql-sql@postgresql.org Subject: Re: LIKE '%%' does not return NULL Message-Id: <20040815211749.115a9f86.postgresql@finner.de> In-Reply-To: References: X-Mailer: Sylpheed version 0.8.10claws72 (GTK+ 1.2.10; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: base64 X-Provags-ID: kundenserver.de abuse@kundenserver.de auth:2d1f62c261f062640f582804a7b1040c X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=3.4 tagged_above=0.0 required=5.0 tests=MIME_BASE64_LATIN, MIME_BASE64_TEXT, RCVD_IN_NJABL_PROXY, YOU_WON X-Spam-Level: *** X-Archive-Number: 200408/137 X-Sequence-Number: 18634 SGksDQoNCnlvdSBzaG91bGQgYWRkaXRpb25hbGx5IGNoZWNrIHdpdGggSVMg TlVMTDoNCg0KU0VMRUNUICogRlJPTSBteXRhYmxlIHdoZXJlIG15ZmllbGQg bGlrZSAnJSUnIE9SIG15ZmllbGQgSVMgTlVMTA0KDQppZiB5b3Ugd2FudCB0 byBnZXQgZmllbGRzIGNvbnRhaW5pbmcgTlVMTCBhcyB3ZWxsLiBBIGZpZWxk IGNvbnRhaW5pbmcgIk5VTEwiIGluDQpmYWN0IGNvbnRhaW5zIG5vdGhpbmcs IG5vdCBldmVuIGFuIGVtcHR5IHN0cmluZywgc28geW91IGNhbm5vdCBjYXRj aCBpdCB3aXRoDQoiJSIuDQoNCkJUVywgdGhpcyBob2xkcyB0cnVlIGVzcGVj aWFsbHkgZm9yIGJvb2xlYW5zOiBUaGV5IGNhbiBjb250YWluIHRoZSB2YWx1 ZXMgInRydWUiDQpvciAiZmFsc2UiIG9yIG5vIHZhbHVlIGF0IGFsbCwgd2hp Y2ggbWVhbnMsIHRoZXkgY29udGFpbiAiTlVMTCIgYW5kIGFyZSBpbiBmYWN0 DQp1bmRlZmluZWQuIFlvdSB3b260dCBjYXRjaCB0aGVtIHdpdGggc29tZXRo aW5nIGxpa2UgIlNFTEVDVCAqIEZST00gYmxhIHdoZXJlDQpibHViYiA8PiBm YWxzZSIsIHlvdSB3aWxsIG9ubHkgZ2V0IHRoZSBmaWVsZHMgY29udGFpbmlu ZyB0cnVlLCBub3QgdGhlIE5VTExzLg0KDQpSZWdhcmRzLCBGcmFuay4NCg0K DQpPbiBXZWQsIDExIEF1ZyAyMDA0IDEzOjIyOjAwICsxMjAwICJUcmFjaSBT dW1wdGVyIiA8VHJhY2kuU3VtcHRlckBvcHVzLmNvLm56Pg0Kc2F0IGRvd24s IHRob3VnaHQgbG9uZyBhbmQgdGhlbiB3cm90ZToNCg0KPiBBIHRlYW0gZGV2 ZWxvcGVyIGhhcyBjaG9zZW4gdGhlIGxhenkgd2F5IG9mIG5vdCBjaGVja2lu ZyBpZiBhIHZhcmlhYmxlDQo+IGV4aXN0cyBvbiBoaXMgUEhQIHBhZ2UgYW5k IGhhcyBjb2RlIHdoaWNoIHByb2R1Y2VzIHRoZSBmb2xsb3dpbmcgU1FMDQo+ IA0KPiBTRUxFQ1QgKiBGUk9NIG15dGFibGUgd2hlcmUgbXlmaWVsZCBpbGlr ZSAnJSUnDQo+IA0KPiBJIGhhdmUgbm90aWNlZCB0aGF0IHRoaXMgc3RhdGVt ZW50IGRvZXMgbm90IHJldHVybiBudWxsIG9yIGVtcHR5IG15ZmllbGQNCj4g cmVjb3Jkcy4NCj4gDQo+IElzIHRoaXMgdGhlIHdheSAoU1FMKSB0byBkbyB0 aGlzPz8NCj4gDQo+IElzIHRoZXJlIGEgYmV0dGVyIHN5bnRheCB0byB0aGUg U1FMPz8NCj4gDQo+IElzIHRoZSBiZXR0ZXIgd2F5IHRvIGNyZWF0ZSB0aGUg c3RhdGVtZW50IGluIFBIUCBpcyB0byBjaGVjayBpZiB0aGUgcGFzc2VkDQo+ IHZhbHVlIDw+ICcnID8/DQo+IA0KPiBPciBpcyB0aGlzIGlzc3VlIGJlaW5n IGZpeGVkIGluIHRoZSBuZXcgVjggdmVyc2lvbiBvZiBwb3N0Z3JlU1FMLg0K PiANCj4gDQo+IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLShlbmQgb2Yg YnJvYWRjYXN0KS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KPiBUSVAg MTogc3Vic2NyaWJlIGFuZCB1bnN1YnNjcmliZSBjb21tYW5kcyBnbyB0byBt YWpvcmRvbW9AcG9zdGdyZXNxbC5vcmcNCg0KDQo=