postgres reg expression quoting

zdzieblo has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: postgres reg expression quoting by moritz (Cardinal) on Apr 01, 2009 at 13:21 UTC
The replies to Perl and PostgreSQL regex should be of some help. That was the first hit for search google with site:perlmonks.org regex postgres - not too hard, is it?	[reply]
Re: postgres reg expression quoting by BrowserUk (Patriarch) on Apr 01, 2009 at 13:27 UTC
See Perl and PostgreSQL regex and particularly Re^2: Perl and PostgreSQL regex. Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error. "Science is about questioning the status quo. Questioning authority". In the absence of evidence, opinion is indistinguishable from prejudice. "Too many [] have been sedated by an oppressive environment of political correctness and risk aversion."	[reply]
Re^2: postgres reg expression quoting by zdzieblo (Acolyte) on Apr 01, 2009 at 14:00 UTC
none of the above answers my question. if user enters '[' for their search query for example I get "ERROR: invalid regular expression: brackets [] not balanced" what I need is a double backlash before every unsafe character	[reply]
Re^3: postgres reg expression quoting by BrowserUk (Patriarch) on Apr 01, 2009 at 14:15 UTC
Perhaps using quotemeta on the user's input before you supply it to DBI's execute method? Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error. "Science is about questioning the status quo. Questioning authority". In the absence of evidence, opinion is indistinguishable from prejudice. "Too many [] have been sedated by an oppressive environment of political correctness and risk aversion."	[reply]
Re^4: postgres reg expression quoting by zdzieblo (Acolyte) on Apr 01, 2009 at 14:44 UTC
Re^3: postgres reg expression quoting by ikegami (Patriarch) on Apr 01, 2009 at 14:31 UTC
That's odd. There's nothing variable in what you presented, so how can any of it be from the user? Please don't post one piece of code and ask about another.	[reply]
Re^4: postgres reg expression quoting by zdzieblo (Acolyte) on Apr 01, 2009 at 14:40 UTC
Re^5: postgres reg expression quoting by ikegami (Patriarch) on Apr 01, 2009 at 15:07 UTC
Some notes below your chosen depth have not been shown here