From 3632a76773dbfc31cf6f99ad831bf13f793871ae Mon Sep 17 00:00:00 2001 From: CiaranG Date: Sun, 14 Sep 2008 16:17:44 -0400 Subject: PostgreSQL: support for full text searching (notice and people) darcs-hash:20080914201744-f6e2c-71b2a3aec4c0b91557465323d79645e7eab2bfd1.gz --- actions/noticesearch.php | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) (limited to 'actions/noticesearch.php') diff --git a/actions/noticesearch.php b/actions/noticesearch.php index c257ecec5..7022109e6 100644 --- a/actions/noticesearch.php +++ b/actions/noticesearch.php @@ -40,7 +40,12 @@ class NoticesearchAction extends SearchAction { # lcase it for comparison $q = strtolower($q); - $notice->whereAdd('MATCH(content) against (\''.addslashes($q).'\')'); + + if(common_config('db','type')=='mysql') { + $notice->whereAdd('MATCH(content) against (\''.addslashes($q).'\')'); + } else { + $notice->whereAdd('to_tsvector(\'english\', content) @@ plainto_tsquery(\''.addslashes($q).'\')'); + } # Ask for an extra to see if there's more. -- cgit v1.2.3-54-g00ecf