Re: LIKE predicate and '\' character

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andy Hallam" <ahm(at)exel(dot)co(dot)uk>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: LIKE predicate and '\' character
Date: 2001-11-07 17:21:36
Message-ID: 5173.1005153696@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Andy Hallam" <ahm(at)exel(dot)co(dot)uk> writes:
> BUT, if I use the LIKE predicate I have to escape the escape.
> Now this must be treated as a bug.

It's not a bug, it's the defined behavior of LIKE. See
http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/functions-matching.html#FUNCTIONS-LIKE

You might find it more convenient to select a different escape
character for LIKE.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephan Szabo 2001-11-07 17:23:27 Re: LIKE predicate and '\' character
Previous Message Tom Lane 2001-11-07 17:15:02 Re: Status of 7.2