Edson Richter <edsonrichter@hotmail.com> writes:
> Thanks, but I've found that some queries using LIKE operator uses table
> scan instead index unless it is defined with varchar_ops in the index...
You mean varchar_pattern_ops? That's an entirely different animal.
regards, tom lane