[GENERAL] Can anyone explain?

set standard_conforming_strings=on;

select 'abcd\efg' like 'abcd\efg' ==> F (I expected it to be T)

select 'abcd\efg' like 'abcd\\efg' ==> T (I expected it to be F)

Thanks

Danny Abraham
BMC Software
CTM&D Business Unit
972-52-4286-513
danny_abraham@bmc.com

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general