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 EEC813A1D89 for ; Mon, 29 Nov 2004 12:19:21 +0000 (GMT) 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 95516-07 for ; Mon, 29 Nov 2004 12:19:15 +0000 (GMT) Received: from qm09.onetel.net.uk (oasis-out-f.onetel.net.uk [212.67.121.107]) by svr1.postgresql.org (Postfix) with SMTP id 631253A1EC8 for ; Mon, 29 Nov 2004 12:19:17 +0000 (GMT) Received: (qmail 75388 invoked from network); 29 Nov 2004 12:19:15 -0000 Received: from unknown (HELO bolek.coachhouse) (212.67.120.115) by qm09h with SMTP; 29 Nov 2004 12:19:15 -0000 Received: (Exim 3.36) #1 (Debian)) protocol: esmtp id 1CYkUr-0007jc-00 ; Mon, 29 Nov 2004 12:19:13 +0000 Message-ID: <41AB13C0.40909@numerixtechnology.de> Date: Mon, 29 Nov 2004 12:19:12 +0000 From: T E Schmitz Reply-To: mailreg@numerixtechnology.de User-Agent: Mozilla Thunderbird 0.7 (Windows/20040616) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: INDEX and LIKE Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/284 X-Sequence-Number: 19602 Hello, I need to be able to perform wildcard searches on a VARCHAR(100) column of the form SELECT * FROM item WHERE serial_no LIKE '%12345678%' Would an index on serial_no do anything at all for this search? -- Regards/Gruß, Tarlika Elisabeth Schmitz