[GENERAL] Default Operator Class for datatype

2011-05-06 Thread Jakub Królikowski
No ideas? 2011/5/4 Jakub Królikowski : > Hello, > > I've set pl_PL.UTF-8 collation on my database after upgrade do 9.0. > That means indexes for varchar column doesn't work anymore in selects > using "like" or "=" operators with that columns. > I know the solution - operator classes - which works

[GENERAL] Default Operator Class for datatype

2011-05-04 Thread Jakub Królikowski
Hello, I've set pl_PL.UTF-8 collation on my database after upgrade do 9.0. That means indexes for varchar column doesn't work anymore in selects using "like" or "=" operators with that columns. I know the solution - operator classes - which works very well. But that means I have to find and recrea