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 an
"Her Goo" <[EMAIL PROTECTED]> writes:
> I want to go a step further, and restrict the results to those
> that begin with string "abc\d".
You need four backslashes for that, because \ is special to both
the string literal parser and the LIKE operator. So ''
reduces to a string constant conta
Her Goo wrote:
> 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)
> # SELECT * FRO