Re: What is impact of "varchar_opts"? - Mailing list pgsql-general

Em 21/01/2013 17:18, Tom Lane escreveu:
> Edson Richter <edsonrichter@hotmail.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