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 |
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 |
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 |