Re: [HACKERS] LIKE wildcards escaping problem

2007-09-24 Thread Heikki Linnakangas
Thea wrote: My problem is that PG behaves differently than other supported DBMSes (MSSQL and MySQL) - when I'm passing a query containing LIKE phrase to it, a double amount of '/' literals is needed to obtain expected result. I do realize that this is caused by a parser 'collapsing' double

Re: [HACKERS] LIKE wildcards escaping problem

2007-09-24 Thread Andrew Dunstan
This is the wrong list to ask this question. This list is about development, not usage. Please ask on -general in future. I presume that where you have / you really mean \. What version of postgres are you using? If you use a modern version with standard_conforming_strings on then you do

Re: [HACKERS] LIKE wildcards escaping problem

2007-09-24 Thread Thea
Yes, I always tend to mix slash and backslash. No idea why ^^'. Postgres version is: PostgreSQL 8.2.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special) and it does have this setting, but it was set to off. Now, having this set I'll have to test it :) Thank you for your