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

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 (view raw or flat)
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

pgsql-performance by date

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

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