Viktor Rosenfeld <listuser36(at)googlemail(dot)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