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

From Tom Lane
Subject Re: What is impact of "varchar_opts"?
Date
Msg-id 8982.1358795889@sss.pgh.pa.us
Whole thread Raw
In response to What is impact of "varchar_opts"?  (Edson Richter <edsonrichter@hotmail.com>)
Responses Re: What is impact of "varchar_opts"?  (Edson Richter <edsonrichter@hotmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Running update in chunks?
Next
From: Edson Richter
Date:
Subject: Re: What is impact of "varchar_opts"?