Hi, how does the RdbiPgSQL library handle, escape for regex queries. For example ; substring(name from E'(\\S+)\\W.*') it works with psql, but not RdbiPgSQL -H?vard

Hi, Havard. It will be very helpful for you to provide a reproducible example (cut and paste), the error message or output, and the expected output as well as the output of sessionInfo(). I do not think there is a limitation for regex queries, but getting the syntax correct may be a bit challenging. Sean 2011/6/26 H?vard Wahl Kongsg?rd <haavard.kongsgaard at="" gmail.com="">: > Hi, how does the RdbiPgSQL library handle, escape for regex queries. > > For example ; > substring(name from E'(\\S+)\\W.*') > > it works with psql, but not RdbiPgSQL > > -H?vard > > _______________________________________________ > Bioconductor mailing list > Bioconductor at r-project.org > https://stat.ethz.ch/mailman/listinfo/bioconductor > Search the archives: http://news.gmane.org/gmane.science.biology.informatics.conductor >