Re: [PERFORM] String matching

[PFC]

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.

---(end of broadcast)---
TIP 6: Have you searched our list archives?
  http://archives.postgresql.org

Re: [PERFORM] String matching

[Ivan Voras]

Stephan Szabo wrote:
You can also create an index using a typename_pattern_ops operator
class which should be usable even with other collations.
Could you give me an example for this, or point me to the relevant 
documentation?

---(end of broadcast)---
TIP 6: Have you searched our list archives?
  http://archives.postgresql.org

Re: [PERFORM] String matching

[Stephan Szabo]

On Mon, 14 Feb 2005, Ivan Voras wrote:

 Stephan Szabo wrote:

  You can also create an index using a typename_pattern_ops operator
  class which should be usable even with other collations.

 Could you give me an example for this, or point me to the relevant
 documentation?

Basically, you could have something like:

create table test_table(a text);
create index test_index on test_table(a text_pattern_ops);

--

http://www.postgresql.org/docs/8.0/interactive/indexes-opclass.html


---(end of broadcast)---
TIP 8: explain analyze is your friend