Postgres Pro
Downloads
Home   >   mailing lists

INDEX and LIKE - Mailing list pgsql-sql

From T E Schmitz
Subject INDEX and LIKE
Date
Msg-id 41AB13C0.40909@numerixtechnology.de
Whole thread Raw
Responses Re: INDEX and LIKE  ("Olivier Hubaut" <olivier@scmbb.ulb.ac.be>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Christoph Haller
Date:
Subject: version 7.4 autocommit removed
Next
From: "Olivier Hubaut"
Date:
Subject: Re: INDEX and LIKE