On 22 March 2013 16:08, Alexander Farber <alexander.far...@gmail.com> wrote:
> Thank you, this works better, but - > the result is correctly "true" now, > but the warning is still there, why? > > # select 'axxxxxyz' ~ '(.)\\1\\1'; > WARNING: nonstandard use of \\ in a string literal > LINE 1: select 'axxxxxyz' ~ '(.)\\1\\1'; > ^ > HINT: Use the escape string syntax for backslashes, e.g., E'\\'. > ?column? > ---------- > t > (1 row) Because backslash is not normally a valid escape character in an SQL string literal. You can turn off the warning in your settings, or you can be explicit about wanting a string literal that can include such escape characters by using the E'<string>' notation. I seem to recall that there's a string literal notation specific to regular expressions as well (R'<regular expression>'?), but I may be mixing up databases... -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest.
