Em 21/01/2013 17:18, Tom Lane escreveu:
> Edson Richter <edsonrichter(at)hotmail(dot)com> writes:
>> I'm wondering why "varchar_opts" is not default operator class for all
>> indexed varchar field.
> varchar has no operators of its own; it just relies on the operators for
> type text. Therefore text_ops is the formally correct choice. The
> varchar_ops opclass is just an alias that's there so we don't get bug
> reports from pedants who expect varchar to have a varchar_ops opclass.
>
> regards, tom lane
>
>
I see. So, what is the overhead of having text_ops in opclass?
Can I define it as default for all my indexes when textual type of any kind?
Thanks,
Edson