The following bug has been logged online:
Bug reference: 5535
Logged by: Jeff Benjamin
Email address: j...@ivertex.com
PostgreSQL version: 8.3.8
Operating system: MacOSX, Linux
Description:Backslash in condition for LIKE statement is not seen
Details:
Seems one
Jeff Benjamin j...@ivertex.com wrote:
Seems one cannot use a backslash character in a LIKE condition.
By default that has special meaning as an escape character.
Try this:
select * from test where pattern like E'\\w%' escape '#';
or this:
select * from test where pattern like
Thanks, that works!
On Jul 1, 2010, at 1:34 PM, Kevin Grittner wrote:
Jeff Benjamin j...@ivertex.com wrote:
Seems one cannot use a backslash character in a LIKE condition.
By default that has special meaning as an escape character.
Try this:
select * from test where pattern like