public inbox for [email protected]
help / color / mirror / Atom feedfunctions-matching correct?
5+ messages / 3 participants
[nested] [flat]
* functions-matching correct?
@ 2002-08-19 20:42 Joe Conway <[email protected]>
0 siblings, 1 reply; 5+ messages in thread
From: Joe Conway @ 2002-08-19 20:42 UTC (permalink / raw)
To: pgsql-docs
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?
Joe
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: functions-matching correct?
@ 2002-08-19 21:21 Tom Lane <[email protected]>
parent: Joe Conway <[email protected]>
0 siblings, 1 reply; 5+ messages in thread
From: Tom Lane @ 2002-08-19 21:21 UTC (permalink / raw)
To: Joe Conway <[email protected]>; +Cc: pgsql-docs
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?
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* LIKE ESCAPE doc fix (was Re: [DOCS] functions-matching correct?)
@ 2002-08-21 06:12 Joe Conway <[email protected]>
parent: Tom Lane <[email protected]>
0 siblings, 2 replies; 5+ messages in thread
From: Joe Conway @ 2002-08-21 06:12 UTC (permalink / raw)
To: Tom Lane <[email protected]>; +Cc: PostgreSQL Patches <[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>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: LIKE ESCAPE doc fix (was Re: [DOCS] functions-matching
@ 2002-08-21 16:09 Bruce Momjian <[email protected]>
parent: Joe Conway <[email protected]>
1 sibling, 0 replies; 5+ messages in thread
From: Bruce Momjian @ 2002-08-21 16:09 UTC (permalink / raw)
To: Joe Conway <[email protected]>; +Cc: Tom Lane <[email protected]>; PostgreSQL Patches <[email protected]>
Your patch has been added to the PostgreSQL unapplied patches list at:
http://candle.pha.pa.us/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---------------------------------------------------------------------------
Joe Conway wrote:
> 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>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to [email protected])
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: LIKE ESCAPE doc fix (was Re: [DOCS] functions-matching
@ 2002-08-22 04:56 Bruce Momjian <[email protected]>
parent: Joe Conway <[email protected]>
1 sibling, 0 replies; 5+ messages in thread
From: Bruce Momjian @ 2002-08-22 04:56 UTC (permalink / raw)
To: Joe Conway <[email protected]>; +Cc: Tom Lane <[email protected]>; PostgreSQL Patches <[email protected]>
Patch applied. Thanks.
---------------------------------------------------------------------------
Joe Conway wrote:
> 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>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to [email protected])
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2002-08-22 04:56 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-08-19 20:42 functions-matching correct? Joe Conway <[email protected]>
2002-08-19 21:21 ` Tom Lane <[email protected]>
2002-08-21 06:12 ` LIKE ESCAPE doc fix (was Re: [DOCS] functions-matching correct?) Joe Conway <[email protected]>
2002-08-21 16:09 ` Re: LIKE ESCAPE doc fix (was Re: [DOCS] functions-matching Bruce Momjian <[email protected]>
2002-08-22 04:56 ` Re: LIKE ESCAPE doc fix (was Re: [DOCS] functions-matching Bruce Momjian <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox