Support of multibyte encoding for pg_trgm

From: Brian Hirt <bhirt(at)mobygames(dot)com>
To: teodor(at)postgresql(dot)org
Cc: Postgresql Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Support of multibyte encoding for pg_trgm
Date: 2009-06-25 15:16:43
Message-ID: 4DB2B240-3BFD-4886-8A70-5F27A807FACC@mobygames.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Teodor,

I ran across a commit message that shows multibyte encoding support in
8.4 and my testing shows that to be the case as well. Is there a
back patch for 8.2? My own quick attempt at creating one didn't work
so well and before I start spending some major time trying I thought
I'd check in with you.

Regards,

Brian Hirt

Postgres Version 8.2 and 8.3
test=# select show_trgm('魔法門英雄無敵2:王位爭奪戰');
show_trgm
---------------
{" 2"," 2 "}
(1 row)

Postgres Version 8.4
test=# select show_trgm('魔法門英雄無敵2:王位爭奪戰');

show_trgm
------------------------------------------------------------------------------------------------------------------------------------------
{0x84af82,0x8426fb,0x886567,0x8986ec,
0x8c3de8,0x9c19f5,0xa0ef88,0xae352c,0xc7de23,0xf449ca,
0x003dc9,0x1003c8,0x143838,0x64a38f,0x650b2a}
(1 row)

Log Message:
-----------
Support of multibyte encoding for pg_trgm

Modified Files:
--------------
pgsql/contrib/pg_trgm:
trgm.h (r1.9 -> r1.10)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_trgm/trgm.h?r1=1.9&r2=1.10
)
trgm_gin.c (r1.5 -> r1.6)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_trgm/trgm_gin.c?r1=1.5&r2=1.6
)
trgm_op.c (r1.10 -> r1.11)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_trgm/trgm_op.c?r1=1.10&r2=1.11
)

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-06-25 15:25:11 Re: Vacuum on the database versus individual tables.
Previous Message David Fetter 2009-06-25 15:12:35 Re: horizontal sharding