|Problems? Is your data what you think it is?|
Perl and PostgreSQL regexby chrishowe (Acolyte)
|on Mar 03, 2009 at 13:10 UTC||Need Help??|
chrishowe has asked for the
wisdom of the Perl Monks concerning the following question:
I am currently trying to use Perl and Postgresql together.
I would like to insert a regex containing a variable into the SQL statement but am unsure of how to do this.
The basic aim of the script will be find sub branches of a root.
e.g. $root = stick, and what I want to find is all branches attached to $root, e.g. stick.1, stick.2, stick.300 etc...
I basically can't get the regex to work at all, I don't think it seems to work like normal Perl regexes, but I am not sure. I have tried a whole multitude of syntaxes.
All help greatly appreciated!