eem to use the index when I used ILIKE instead of LIKE.Thanks,
Brendan Duddridge | CTO | 403-277-5591 x24 |
[EMAIL PROTECTED]
ClickSpace Interactive Inc. Suite L100, 239 - 10th Ave. SE Calgary, AB T2G 0V9
http://www.clickspace.com On Feb 21, 2006, at 1:28 PM, I
this trick did the job. thanks.On 2/21/06, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
Scott Marlowe wrote:> On Tue, 2006-02-21 at 09:57, Ibrahim Tekin wrote:> > hi,
> > i have btree index on a text type field. i want see rows which starts> > with certain characters on tha
PROTECTED] <[EMAIL PROTECTED]> wrote:
On Tue, Feb 21, 2006 at 05:57:12PM +0200, Ibrahim Tekin wrote:> i have btree index on a text type field. i want see rows which starts with
> certain characters on that field. so i write a query like this:> SELECT * FROM mytable WHERE myfield
hi,i have btree index on a text type field. i want see rows which starts with certain characters on that field. so i write a query like this:SELECT * FROM mytable WHERE myfield LIKE 'john%'since this condition is from start of the field, query planner should use index to find such elements but expl
