Em 21/01/2013 17:18, Tom Lane escreveu:
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
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
