Re: record identical operator - Review

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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +