[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
CVS Update: gleipnir
- To: cvs@lists.cleannorth.org
- Subject: CVS Update: gleipnir
- From: Dan Brosemer <odin@cleannorth.org>
- Date: Sun, 17 Aug 2008 01:35:15 -0400 (EDT)
- List-help: <mailto:cvs-request@lists.cleannorth.org?subject=help>
- List-post: <mailto:cvs@lists.cleannorth.org>
- List-subscribe: <mailto:cvs-request@lists.cleannorth.org?subject=subscribe>
- List-unsubscribe: <mailto:cvs-request@lists.cleannorth.org?subject=unsubscribe>
- Resent-date: Sun, 17 Aug 2008 01:35:18 -0400 (EDT)
- Resent-from: cvs@lists.cleannorth.org
- Resent-message-id: <t1LXRB.A.-zG.si7pIB@skroob.cleannorth.org>
- Resent-sender: cvs-request@lists.cleannorth.org
Log Message:
-----------
Upgrade to PostgreSQL 8.3 function names
Modified Files:
--------------
gleipnir/perllib/Gleipnir:
Search.pm
Revision Data
-------------
Index: Search.pm
===================================================================
RCS file: /cvs/gleipnir/perllib/Gleipnir/Search.pm,v
retrieving revision 1.5
retrieving revision 1.6
diff -Lperllib/Gleipnir/Search.pm -Lperllib/Gleipnir/Search.pm -u -r1.5 -r1.6
--- perllib/Gleipnir/Search.pm
+++ perllib/Gleipnir/Search.pm
@@ -83,10 +83,10 @@
select * from (
select distinct on (F.$this->{id})
F.$this->{id},
-headline($doc,TS.q),
-rank_cd(F.idxFTI, TS.q) as rank
+ts_headline($doc,TS.q),
+ts_rank_cd(F.idxFTI, TS.q) as rank
from $this->{from} as F,
-(select to_tsquery(?) as q) as TS
+(select to_tsquery('english', ?) as q) as TS
where F.idxFTI @@ TS.q order by F.$this->{id} desc ) as foo
order by foo.rank desc
EOT
- Prev by Date: CVS Update: gleipnir
- Next by Date: CVS Update: svartalfheim.net
- Previous by thread: CVS Update: gleipnir
- Next by thread: CVS Update: gleipnir
- Index(es):