Re: [GENERAL] Quoting/Escaping - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: [GENERAL] Quoting/Escaping
Date
Msg-id Pine.LNX.4.20.9911292205430.658-100000@localhost.localdomain
Whole thread Raw
In response to Quoting/Escaping  (Bill Sneed <bsneed@mint.net>)
List pgsql-general
On 1999-11-28, Bill Sneed mentioned:

> I'd like to be able to find a book title that contain C++ in the
> title....
>
> select * from books where title ~* 'C++'   doesn't work.
>
> I've tried all the basic methods of quoting the Plus (+) signs but
> none seem to work...

select * from books where title ~[*] 'C\\+\\+'

The reason seems to be that the parser *and* the regexp routine do their
thing with unquoting.

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


pgsql-general by date:

Previous
From: Miguel Montes
Date:
Subject: Table corruption and other questions
Next
From:
Date:
Subject: Re: [GENERAL] Re: PL/pgsql or C/C++