Re: Can anyone explain?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, danny_abraham(at)yahoo(dot)com
Subject: Re: Can anyone explain?
Date: 2008-09-28 17:34:45
Message-ID: 9517.1222623285@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Abraham, Danny" <danny_abraham(at)bmc(dot)com> writes:
> set standard_conforming_strings=on;
> select 'abcd\efg' like 'abcd\efg' ==> F (I expected it to be T)
> select 'abcd\efg' like 'abcd\\efg' ==> T (I expected it to be F)

Backslash is the default LIKE escape character.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Seb 2008-09-29 00:31:52 Re: inserting to a multi-table view
Previous Message Simon Riggs 2008-09-28 16:18:05 Re: pg_start_backup() takes too long