LIKE ESCAPE doc fix (was Re: [DOCS] functions-matching correct?)

From: Joe Conway <mail(at)joeconway(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: LIKE ESCAPE doc fix (was Re: [DOCS] functions-matching correct?)
Date: 2002-08-21 06:12:54
Message-ID: 3D632F66.60905@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-patches

Tom Lane wrote:
> Joe Conway <mail(at)joeconway(dot)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

Attachment Content-Type Size
like-escape-doc.patch text/plain 980 bytes

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2002-08-21 16:09:19 Re: LIKE ESCAPE doc fix (was Re: [DOCS] functions-matching
Previous Message Bruce Momjian 2002-08-20 21:24:04 Re: Add cross-references re schema search path

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2002-08-21 15:56:46 Re: small mistakes in func.sgml
Previous Message Alvaro Herrera 2002-08-21 05:44:50 Re: small mistakes in func.sgml