Re: [COMMITTERS] 'pgsql/src/backend/parser gram.y'

> Update of /usr/local/cvsroot/pgsql/src/backend/parser
> In directory hub.org:/tmp/cvs-serv80148/parser
> 
> Modified Files:
>     gram.y 
> Log Message:
> Repair recently-introduced error in makeIndexable for LIKE:
> a non-leading % would be put into the >=/<= patterns.  Also, repair
> longstanding confusion about whether %% means a literal %%.  The SQL92
> doesn't say any such thing, and textlike() knows that, but gram.y didn't.
> 
> 

Houston, we have a problem.  DoMatch has:
           case '%':               /* %% is the same as % according to the SQL standard */               /* Advance
pastall %'s */               while (*p == '%')
 

Don't we want %% to be %?

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026