Re^2: Perl and PostgreSQL regex

[chrishowe]

See now I have tried your first solution but all I get is the following error:

WARNING:  nonstandard use of escape in a string literal
LINE 3:                         AND branch ~ '$root\.\d...
                                             ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'..

Which is confusing me a little :-)