Re: Can't find documentation for ~=~ operator

Viktor Rosenfeld <listuser36@googlemail.com> writes:
> I can't find the documentation of the ~=~ operator anywhere on the
> PostgreSQL homepage.

Which version's documentation are you reading?  It's gone as of 8.4.

> FYI, I use ~=~ for equality checks, so I can use the same index for
> equality and regexp pattern matching on a varchar field.  The index is
> built with varchar_pattern_ops.

Use plain old '=' as of 8.4.

            regards, tom lane