The following bug has been logged online: Bug reference: 1197 Logged by: Eleas
Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: Linux phantom 2.6.5-gentoo-r1 #1 Sun Jun 27 18:33:50 MSD 2004 i686 AMD Athlon(tm) Processor AuthenticAMD GNU/Linux Description: index bug Details: Hello I have DB under UTF8. A field of my table have btree index. But this index works incorrectly if this field content localized data. For example, how you can explain this: select object_id, name from main_objects where name='Мебель'; And I recieve the felouwing result set: object_id name 185 Мебель 574 Модемы Please resolve this problem as soon as posible. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org