Posted on 2005-04-11 14:03:09-07 by zby
SQL functions in WHERE clause
I need to use a SQL function in the WHERE clause like:
SELECT * FROM link WHERE cachevect @@ tsquery('?')
I cannot find any way to do it with the placeholder - the only solution I found is to use the scalar reference like:
my $where = q{@@ tsquery('} . quote($val) . q{')}; { cachevect => \$where }
but then I loose all the convenience of using binded parameters. Are there any plans to solve that?
Direct Responses: 346 | Write a response
Perl Weekly newsletter
A free weekly newsletter for people who are busy to read all the blogs. click here to check it out.