Re: [SQL] LIKE on index not working

2004-07-22 Thread Chris Cox
abases? What a pain! Chris - Original Message - From: "Peter Eisentraut" <[EMAIL PROTECTED]> To: "Chris Cox" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, July 22, 2004 10:41 PM Subject: Re: [SQL] LIKE on index not working > Am Do

[SQL] LIKE on index not working

2004-07-22 Thread Chris Cox
Hi all, For some reason I just can't get this to use the index for the following query. I'm using PostgreSQL 7.3.4. Here's the details (let me know if you need anymore information to provide any assistance): Indexes: person_pkey primary key btree (personid), ix_person_active btree (bac