[Dbix-class] Need help with PgSQL fulltext search queries
Alex Kapranoff
ka at nadoby.ru
Thu May 7 08:16:44 GMT 2009
Good day to all!
(this is either a DBIx::Class, SQL::Abstarct or PgSQL fulltext search
+ Perl question)
Can someone please help "+selecting" a function with several parameters?
This is the code we came up with. The problem is, $search_text doesn't
get quoted when sent to DB server.
'+select' => [
\[q{ts_headline('ru', html, plainto_tsquery('ru', ?), 'StartSel =
<b>, StopSel = </b>')},
[dummy => $search_text],
]],
'+as' => ['html_hilited'],
More information about the DBIx-Class
mailing list