Postgres Pro
Downloads
Home   >   mailing lists

Using index for "like 'ABC%'" type query - Mailing list pgsql-general

From lec
Subject Using index for "like 'ABC%'" type query
Date
Msg-id 3E9F6974.1020405@pc.jaring.my
Whole thread Raw
Responses Re: Using index for "like 'ABC%'" type query  (Jeffrey Melloy <jmelloy@visualdistortion.org>)
Re: Using index for "like 'ABC%'" type query  (Andrew Sullivan <andrew@libertyrms.info>)
Re: Using index for "like 'ABC%'" type query  (Darko Prenosil <darko.prenosil@finteh.hr>)
List pgsql-general
Tree view 
For current version of postgresql, is it possible for a query like below
to utilize an index?

select item_name from item where item_code like 'ABC%';

Earlier versions of postgresql, eg, 6.5.3 can utilize the index.


Thanks,
Thomas.

pgsql-general by date:

Previous
From: Jeffrey Melloy
Date:
Subject: 7.3 PDF documentation
Next
From: Jeffrey Melloy
Date:
Subject: Re: Using index for "like 'ABC%'" type query