On Fri, 2 Jul 2004, Jon Valvatne wrote:
Pasted below, I demonstrate two queries which both produce the same two
records in their result set (the two objects which have my full name in
their name field). Based on my experiences with other DBMS, I would have
thought Postgres could do a simple
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
---(end of broadcast)---