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
)
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 |