Skip site navigation (1) Skip section navigation (2)

Re: functions-matching correct?

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 (view raw or flat)
Thread:
Lists: pgsql-docspgsql-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

In response to

Responses

pgsql-docs by date

Next:From: Oliver ElphickDate: 2002-08-20 05:49:45
Subject: Add cross-references re schema search path
Previous:From: Joe ConwayDate: 2002-08-19 20:42:35
Subject: functions-matching correct?

pgsql-patches by date

Next:From: Rod TaylorDate: 2002-08-20 03:45:52
Subject: Truncate
Previous:From: Tom LaneDate: 2002-08-19 21:03:53
Subject: Re: first cut at PL/PgSQL table functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group