Viktor Rosenfeld <listuser36@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
