Hi,
We have a problem with backslashes in queries containing LIKE.
insert into table (field) values ('IM\\test')
select * from table where field = 'IM\\test'
returns one record
select * from table where field LIKE 'IM\\%'
returns no record
Why is postgres behaves like that ?
Can someone help us ?
Scripts for testing purpose have been attached.
Mickael Faivre-Macon.
Attachment:
creat_table.sql
Description: Binary data
Attachment:
insert_values.sql
Description: Binary data
Attachment:
select_values.sql
Description: Binary data
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
