public inbox for [email protected]
help / color / mirror / Atom feedFrom: Joe Conway <[email protected]>
To: Tom Lane <[email protected]>
Cc: PostgreSQL Patches <[email protected]>
Subject: LIKE ESCAPE doc fix (was Re: [DOCS] functions-matching correct?)
Date: Tue, 20 Aug 2002 23:12:54 -0700
Message-ID: <[email protected]> (raw)
References: <[email protected]>
<[email protected]>
Tom Lane wrote:
> Joe Conway <[email protected]> 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
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>
Attachments:
[text/plain] like-escape-doc.patch (980B, 2-like-escape-doc.patch)
download | inline diff:
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>
view thread (5+ messages) latest in thread
reply
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: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: LIKE ESCAPE doc fix (was Re: [DOCS] functions-matching correct?)
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox