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