Thread: functions-matching correct?

7.2.1 docs:
http://www.postgresql.org/idocs/index.php?functions-matching.html#FUNCTIONS-LIKE

" It's also possible to select no escape character by writing ESCAPE ''.
In this case there is no way to turn off the special meaning of
underscore and percent signs in the pattern."

7.3 development docs:
http://developer.postgresql.org/docs/postgres/functions-matching.html#FUNCTIONS-LIKE

" It's also possible to select no escape character by writing ESCAPE ''.
This effectively disables the escape mechanism and turns off the special
meaning of underscore and percent signs in the pattern."

I think the former is still correct, isn't it?

Joe

Joe Conway <mail@joeconway.com> writes:
> 7.2.1 docs:
> http://www.postgresql.org/idocs/index.php?functions-matching.html#FUNCTIONS-LIKE

> " It's also possible to select no escape character by writing ESCAPE ''.
> In this case there is no way to turn off the special meaning of
> underscore and percent signs in the pattern."

> 7.3 development docs:
> http://developer.postgresql.org/docs/postgres/functions-matching.html#FUNCTIONS-LIKE

> " It's also possible to select no escape character by writing ESCAPE ''.
> This effectively disables the escape mechanism and turns off the special
> meaning of underscore and percent signs in the pattern."

> I think the former is still correct, isn't it?

Yes, as is easily proven by experiment:

regression=# select 'foo' LIKE 'f%';
 ?column?
----------
 t
(1 row)

regression=# select 'foo' LIKE 'f%' escape '';
 ?column?
----------
 t
(1 row)

Who put that change in?

            regards, tom lane