From: Her Goo <gu_he@msn.com>
To: pgsql-sql@postgresql.org
Subject: sql: "LIKE" problem
Date: Mon, 14 Mar 2005 14:16:19 +0800
Message-ID: <BAY11-DAV4899E308FCFAA7E626003F85560@phx.gbl> (raw)
I am using "postgresql-7.3.2-1" now!
I met a problem when using "LIKE" in "WHERE" clause.
For example, a table named "t_test", and its data looks like below:
# SELECT * FROM t_test;
id | c_name
----+--------
1 | abc\
2 | abc\de
(2 rows)
The thing I want to do is searching in above table and restricting
the results to those that begin with string "abc\". The search result is:
# SELECT * FROM t_test WHERE c_name LIKE 'abc\%';
id | c_name
----+--------
1 | abc\
2 | abc\de
(2 rows)
I want to go a step further, and restrict the results to those
that begin with string "abc\d". The search result is:
# SELECT * FROM t_test WHERE c_name LIKE 'abc\d%';
id | c_name
----+--------
(0 rows)
I don't know why the result is "0 rows"(why not is "1 rows"),
And I have trid "LIKE 'abc\\d%'", the result is also "0 rows".
Is this a bug for "postgresql-7.3.2-1" ?
Or how can I search a field when it contains a backslash('\') ?
Thanks!!!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gu_he@msn.com
Subject: Re: sql: "LIKE" problem
In-Reply-To: <BAY11-DAV4899E308FCFAA7E626003F85560@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox