Re: Backslash Bug in ARE Class-Shorthand Escape? - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: Backslash Bug in ARE Class-Shorthand Escape?
Date
Msg-id 200312060921.35631.peter_e@gmx.net
Whole thread Raw
In response to Backslash Bug in ARE Class-Shorthand Escape?  (david@fetter.org (David Fetter))
List pgsql-bugs
David Fetter wrote:
> Kind people,
>
> I have a little puzzlement.  In the first select, I double the
> backslash and return true.  In the second, I don't and get false.
> Have I missed something important in the docs?

Yes:

"""
Note: Remember that the backslash (\) already has a special meaning in
PostgreSQL string literals. To write a pattern constant that contains a
backslash, you must write two backslashes in the statement.
"""

pgsql-bugs by date:

Previous
From: Joe Conway
Date:
Subject: Re: Backslash Bug in ARE Class-Shorthand Escape?
Next
From: Joe Conway
Date:
Subject: Re: Backslash Bug in ARE Class-Shorthand Escape?