normally you shouldn't have to do anything, it should just work :
select field from table where field like 'abc%'
If it does not use the index, I saw on the mailing list that the locale could be an issue.
Oh yes, I forgot about that :( I do have LC_COLLATE (on latin2)...
It's a shame PostgreSQL doesn't allow collation rules on specific fields - this field I'm using here will always be 7bit ASCII :(
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
