On Wed, Jul 28, 2010 at 12:15 PM, Little, Douglas <douglas.lit...@orbitz.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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql