INDEX and LIKE

From: T E Schmitz <mailreg(at)numerixtechnology(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: INDEX and LIKE
Date: 2004-11-29 12:19:12
Message-ID: 41AB13C0.40909@numerixtechnology.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Olivier Hubaut 2004-11-29 13:45:42 Re: INDEX and LIKE
Previous Message Christoph Haller 2004-11-29 09:47:21 version 7.4 autocommit removed