Re: = or LIKE ? - Mailing list pgsql-sql

From Tom Lane
Subject Re: = or LIKE ?
Date
Msg-id 23452.1234723360@sss.pgh.pa.us
Whole thread Raw
In response to = or LIKE ?  (Jesper Krogh <jesper@krogh.cc>)
Responses Re: = or LIKE ?
List pgsql-sql
Jesper Krogh <jesper@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


pgsql-sql by date:

Previous
From: Jesper Krogh
Date:
Subject: = or LIKE ?
Next
From: Jesper Krogh
Date:
Subject: Re: = or LIKE ?