Re: String matching

From: PFC <lists(at)boutiquenumerique(dot)com>
To: "Ivan Voras" <ivoras(at)fer(dot)hr>, pgsql-performance(at)postgresql(dot)org
Subject: Re: String matching
Date: 2005-02-14 20:08:39
Message-ID: opsl7d8pkvth1vuj@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


normally you shouldn't have to do anything, it should just work :

> select field from table where field like 'abc%'

CREATE INDEX ... ON table( field );

that's all

If it does not use the index, I saw on the mailing list that the locale
could be an issue.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ivan Voras 2005-02-14 20:31:46 Re: String matching
Previous Message Ivan Voras 2005-02-14 19:57:27 String matching