Thank you, this works better, but - On Fri, Mar 22, 2013 at 3:57 PM, Rob Sargent <robjsargent@xxxxxxxxx> wrote: > On 03/22/2013 08:53 AM, Alexander Farber wrote: >> >> # select 'axxxxxyz' ~ '(.)\1\1'; >> WARNING: nonstandard use of escape in a string literal >> LINE 1: select 'axxxxxyz' ~ '(.)\1\1'; >> ^ >> HINT: Use the escape string syntax for escapes, e.g., E'\r\n'. >> ?column? >> ---------- >> f >> (1 row) >> >> >> The table 9-18 at >> http://www.postgresql.org/docs/8.4/static/functions-matching.html >> suggests that using \1 as above should be ok.... 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) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
