diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2014-12-11 16:59:06 +0000 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2014-12-11 16:59:06 +0000 |
| commit | c1d2f806d972d7c483546d6ac0e5df8a0455ba3a (patch) | |
| tree | e461394275f032aeafa9d7e7ff8cc637dc9087ee | |
| parent | Tweaks for using slicer (diff) | |
| download | p2pvr-c1d2f806d972d7c483546d6ac0e5df8a0455ba3a.tar.bz2 p2pvr-c1d2f806d972d7c483546d6ac0e5df8a0455ba3a.tar.xz p2pvr-c1d2f806d972d7c483546d6ac0e5df8a0455ba3a.zip | |
Add missing sort criteria
| -rw-r--r-- | p2pvr/daemon/sql/SI_eventSearch.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/p2pvr/daemon/sql/SI_eventSearch.sql b/p2pvr/daemon/sql/SI_eventSearch.sql index 3a43b41..7ff0cf7 100644 --- a/p2pvr/daemon/sql/SI_eventSearch.sql +++ b/p2pvr/daemon/sql/SI_eventSearch.sql @@ -30,5 +30,5 @@ and (event_tsvector(e) @@ plainto_tsquery(?) or ?::text is null) order by max(ts_rank(event_tsvector(e), plainto_tsquery(?))) over(partition by title) desc, max(ts_rank(event_tsvector(e), plainto_tsquery(?))) over(partition by title, subtitle, description) desc, - e.title, e.subtitle, e.starttime, e.serviceId, e.eventId + e.title, e.subtitle, e.description, e.starttime, e.serviceId, e.eventId |