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



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to