Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 3DBFE4758BB
	for <pgsql-patches@postgresql.org>;
	Wed, 21 Aug 2002 02:13:42 -0400 (EDT)
Received: from joeconway.com (unknown [63.210.180.150])
	by postgresql.org (Postfix) with ESMTP id 9B53E475897
	for <pgsql-patches@postgresql.org>;
	Wed, 21 Aug 2002 02:13:41 -0400 (EDT)
Received: from [192.168.5.2] (account jconway HELO joeconway.com)
	by joeconway.com (CommuniGate Pro SMTP 3.5.9)
	with ESMTP-TLS id 1291682; Tue, 20 Aug 2002 23:01:25 -0700
Message-ID: <3D632F66.60905@joeconway.com>
Date: Tue, 20 Aug 2002 23:12:54 -0700
From: Joe Conway <mail@joeconway.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.0.0) Gecko/20020530
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL Patches <pgsql-patches@postgresql.org>
Subject: LIKE ESCAPE doc fix (was Re: [DOCS] functions-matching correct?)
References: <3D61583B.6000608@joeconway.com> <26945.1029792099@sss.pgh.pa.us>
Content-Type: multipart/mixed; boundary="------------080000020609010209030106"
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200208/396
X-Sequence-Number: 4932

This is a multi-part message in MIME format.
--------------080000020609010209030106
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Tom Lane wrote:
> 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?

Here's a small doc patch to fix this issue. Please apply.

Thanks,

Joe


--------------080000020609010209030106
Content-Type: text/plain;
 name="like-escape-doc.patch"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
 filename="like-escape-doc.patch"

Index: doc/src/sgml/func.sgml
===================================================================
RCS file: /opt/src/cvs/pgsql-server/doc/src/sgml/func.sgml,v
retrieving revision 1.114
diff -c -r1.114 func.sgml
*** doc/src/sgml/func.sgml	21 Aug 2002 05:25:49 -0000	1.114
--- doc/src/sgml/func.sgml	21 Aug 2002 05:42:49 -0000
***************
*** 2238,2246 ****
     <para>
      It's also possible to select no escape character by writing
      <literal>ESCAPE ''</literal>.  This effectively disables the
!      escape mechanism and
!      turns off the special meaning of underscore and percent signs in
!     the pattern.
     </para>
  
     <para>
--- 2238,2245 ----
     <para>
      It's also possible to select no escape character by writing
      <literal>ESCAPE ''</literal>.  This effectively disables the
!     escape mechanism, which makes it impossible to turn off the
!     special meaning of underscore and percent signs in the pattern.
     </para>
  
     <para>

--------------080000020609010209030106--