Edson Richter <edsonrichter@xxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
