Re: Postgres doesn't use indexes for prefix matching?

Your message from 7/2 just showed up today.

> db=# explain analyze SELECT id FROM object WHERE name ~ '^Jon V';

I use leading substring indexing all the time. Try:

SELECT id FROM object WHERE name like 'Jon V%';

Wes