Re: LIKE with pattern containing backslash

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jack Orenstein <jack(dot)orenstein(at)hds(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, Matt McDonald <matt(dot)mcdonald(at)hds(dot)com>
Subject: Re: LIKE with pattern containing backslash
Date: 2009-02-03 17:16:59
Message-ID: 28862.1233681419@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jack Orenstein <jack(dot)orenstein(at)hds(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alan Hodgson 2009-02-03 17:17:40 Re: Vacuums taking forever :(
Previous Message Sam Mason 2009-02-03 17:10:09 Re: embedded pgsql media-failure