Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Mathieu Fenniak wrote:
> >> I noticed that (SELECT E'\\' LIKE E'\\') returns false,
> 
> > I believe this is caused because backslash is the default escape
> > character for LIKE, so you need:
> >     test=> SELECT E'\\' LIKE E'\\\\';
> 
> Yeah.  The given case is actually an invalid LIKE pattern.  I wonder
> whether we should make LIKE throw error for an invalid pattern.
> You get an error for the corresponding case in regex:
> 
> regression=# select E'\\' ~ E'\\';
> ERROR:  invalid regular expression: invalid escape \ sequence
> 
> but IIRC the LIKE code just silently ignores a trailing escape
> character.

Yes, I think we should throw an error;  the original query looked odd to
me too.

-- 
  Bruce Momjian  <[EMAIL PROTECTED]>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to