Re: 'like' refuses to use an index???
От | Mike Nolan |
---|---|
Тема | Re: 'like' refuses to use an index??? |
Дата | |
Msg-id | 200312302140.hBULeeAo002661@gw.tssi.com обсуждение исходный текст |
Ответ на | Re: 'like' refuses to use an index??? (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: 'like' refuses to use an index???
Re: 'like' refuses to use an index??? |
Список | pgsql-general |
> You didn't initdb in C locale ... The documentation section on localization could use some enhancements and maybe some more examples. The 'c' locale isn't very well defined in the docs, except to say that it is 'special' and is the default if no other locale is defined. That section doesn't mention that you need that locale to get 'like' to use an index, for example. However, I think RH always sets the LANG environmental variable, so that's going to be picked up by initdb, which means that the C locale will NOT be used unless specifically asked for. Other OS packages may also force the choice of a default LANG value. Dumb question of the hour: How does one find out what locale a DB is initialized in? -- Mike Nolan
В списке pgsql-general по дате отправления: