Jesper Krogh <jes...@krogh.cc> writes: > Shouldnt the like operator do the same as the = if there occours no > wildcards and stuff in the string?
If there are also no escape characters, then yeah.
FWIW, 8.4 will complain about this case:
regression=# select E'\\' like E'\\';
ERROR: LIKE pattern must not end with escape character
regards, tom lane
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
