Viktor Rosenfeld <listuse...@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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
