| From: | pma(at)commandprompt(dot)com |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgreslq(dot)org |
| Subject: | can't find a\bc with select query |
| Date: | 2001-03-28 17:08:28 |
| Message-ID: | 3AC21A8C.84E53197@commandprompt.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I'm using PostgreSQL version 7.1, and I'm having trouble with the LIKE
statement. How would I find the value "a\bc"? I tried using the
backslash to escape it: LIKE 'a\\b%';
If I specify: LIKE 'a\\bc', then it works, but if I wanted it to look
for consecetive characters after the c, using the %, then it returns
other values besides what I'm looking for.
I also have the same problem with percent (%). I have a test string
with the value "ab%c", and I want to look for that using LIKE. I tried:
LIKE 'ab\\%c', LIKE 'ab%%', and LIKE 'ab%_', but these statements not
only returned what I was looking for, but also other values: "abc",
"ABC", and "Abc".
Phuong
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mihai Gheorghiu | 2001-03-28 18:04:01 | View primary key |
| Previous Message | Tom Lane | 2001-03-28 15:22:56 | Re: pg_dump potential bug |