| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Bill Sneed <bsneed(at)mint(dot)net> |
| Cc: | "pgsql-general(at)hub(dot)org" <pgsql-general(at)hub(dot)org> |
| Subject: | Re: [GENERAL] Quoting/Escaping |
| Date: | 1999-11-29 21:06:49 |
| Message-ID: | Pine.LNX.4.20.9911292205430.658-100000@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 1999-11-29 22:35:42 | Re: [HACKERS] Re: [GENERAL] Update of bitmask type |
| Previous Message | Miguel Montes | 1999-11-29 19:18:59 | Table corruption and other questions |