Skip site navigation (1) Skip section navigation (2)

Re: String matching

From: Ivan Voras <ivoras(at)fer(dot)hr>
To: PFC <lists(at)boutiquenumerique(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: String matching
Date: 2005-02-14 20:31:46
Message-ID: 42110AB2.1010903@fer.hr (view raw or flat)
Thread:
Lists: pgsql-performance
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 :(


In response to

Responses

pgsql-performance by date

Next:From: Stephan SzaboDate: 2005-02-14 20:42:14
Subject: Re: String matching
Previous:From: PFCDate: 2005-02-14 20:08:39
Subject: Re: String matching

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group