in reply to Re: Perl and PostgreSQL regex
in thread Perl and PostgreSQL regex

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 :-)