= or LIKE ? - Mailing list pgsql-sql

From Jesper Krogh
Subject = or LIKE ?
Date
Msg-id 499857A7.4000201@krogh.cc
Whole thread Raw
Responses Re: = or LIKE ?
List pgsql-sql
Hi.

Can anyone explain me this behavior?

testdb=# select E'\\' = E'\\'; ?column?
---------- t
(1 row)

testdb=# select E'\\' like E'\\'; ?column?
---------- f
(1 row)


Shouldnt the like operator do the same as the = if there occours no 
wildcards and stuff in the string?

-- 
Jesper


pgsql-sql by date:

Previous
From: Tovo Rabemanantsoa
Date:
Subject: Re: Grass Root Protectionism
Next
From: Tom Lane
Date:
Subject: Re: = or LIKE ?