To: Joe Conway <mail@joeconway.com>
Cc: pgsql-docs@postgresql.org
Subject: Re: functions-matching correct? 
In-reply-to: <3D61583B.6000608@joeconway.com> 
References: <3D61583B.6000608@joeconway.com>
Comments: In-reply-to Joe Conway <mail@joeconway.com>
	message dated "Mon, 19 Aug 2002 13:42:35 -0700"
Date: Mon, 19 Aug 2002 17:21:39 -0400
Message-ID: <26945.1029792099@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

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