On Wed, Jul 28, 2010 at 12:15 PM, Little, Douglas
<DOUGLAS(dot)LITTLE(at)orbitz(dot)com> wrote:
> Wes.
>
> You probably missed the part in bold. You need to double the backslash.
>
> select 'ab5c' like '%\_c'
>
> t
>
Why doesn't this work?
select * from table where field::text ilike '%\\\%'
WARNING: nonstandard use of \\ in a string literal
-wes