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