On Thu, Oct 3, 2013 at 10:46:05AM -0700, Kevin Grittner wrote:
> > opcname
> > ---------------------
> > varchar_ops
> > kd_point_ops
> > cidr_ops
> > text_pattern_ops
> > varchar_pattern_ops
> > bpchar_pattern_ops
> > (6 rows)
> >
> > Do these all have operators defined too?
>
> Every operator class is associated with operators. For example,
> while text_pattern_ops uses the same = and <> operators as the
> default text opclass (because that already uses memcmp), it adds
> ~>~, ~>=~, ~<~, and ~<=~ operators which also use memcmp (ignoring
> character encoding and collation).
OK, my questions have been answered and I am no longer concerned about
this patch causing "equality" confusion for our users.
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com
+ It's impossible for everything to be true. +