Support of multibyte encoding for pg_trgm

Поиск
Список
Период
Сортировка
От Brian Hirt
Тема Support of multibyte encoding for pg_trgm
Дата
Msg-id 4DB2B240-3BFD-4886-8A70-5F27A807FACC@mobygames.com
обсуждение исходный текст
Список 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
)


В списке pgsql-general по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: horizontal sharding
Следующее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: Re: Vacuum on the database versus individual tables.