Postgres Pro
Downloads
Home   >   mailing lists

Re: LIKE with pattern containing backslash - Mailing list pgsql-general

From Tom Lane
Subject Re: LIKE with pattern containing backslash
Date
Msg-id 28862.1233681419@sss.pgh.pa.us
Whole thread Raw
In response to LIKE with pattern containing backslash  (Jack Orenstein <jack.orenstein@hds.com>)
Responses Re: LIKE with pattern containing backslash
List pgsql-general
Tree view 
Jack Orenstein <jack.orenstein@hds.com> writes:
> I wrote a JDBC test program, with two variants.

My Java is pretty weak, but doesn't it think that backslash is special
in string literals?  If I assume that each pair of \'s in your examples
went to the database as one \, then the results are what I'd expect.

            regards, tom lane

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Full text index not being used
Next
From: Scott Marlowe
Date:
Subject: Re: Fastest way to drop an index?