From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Joe Conway <mail(at)joeconway(dot)com> |
Cc: | pgsql-docs(at)postgresql(dot)org |
Subject: | Re: functions-matching correct? |
Date: | 2002-08-19 21:21:39 |
Message-ID: | 26945.1029792099@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-patches |
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?
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2002-08-20 05:49:45 | Add cross-references re schema search path |
Previous Message | Joe Conway | 2002-08-19 20:42:35 | functions-matching correct? |
From | Date | Subject | |
---|---|---|---|
Next Message | Rod Taylor | 2002-08-20 03:45:52 | Truncate |
Previous Message | Tom Lane | 2002-08-19 21:03:53 | Re: first cut at PL/PgSQL table functions |