pg_trgm: unicode string not working

From: Sushant Sinha <sushant354(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: pg_trgm: unicode string not working
Date: 2011-06-12 11:33:40
Message-ID: 1307878420.1880.4.camel@dragflick
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I am using pg_trgm for spelling correction as prescribed in the
documentation. But I see that it does not work for unicode sring. The
database was initialized with utf8 encoding and the C locale.

Here is the table:
\d words
Table "public.words"
Column | Type | Modifiers
--------+---------+-----------
word | text |
ndoc | integer |
nentry | integer |
Indexes:
"words_idx" gin (word gin_trgm_ops)

Query: select word from words where word % 'कतद';

I get an error:

ERROR: GIN indexes do not support whole-index scans

Any idea what is wrong?

-Sushant.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Florian Pflug 2011-06-12 11:46:08 Boolean operators without commutators vs. ALL/ANY
Previous Message richhguard-monotone 2011-06-12 11:26:16 PATCH: CreateComments: use explicit indexing for ``values''