On Mon, 14 Feb 2005, Ivan Voras wrote:

> PFC wrote:
> >
> >     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 :(

You can also create an index using a <typename>_pattern_ops operator
class which should be usable even with other collations.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to