diff options
| author | Marc Alexander <admin@m-a-styles.de> | 2018-01-07 11:06:09 +0100 |
|---|---|---|
| committer | Marc Alexander <admin@m-a-styles.de> | 2018-01-07 11:06:09 +0100 |
| commit | f26b2c00de5702403e3c5983dedf99ac6dc06d8c (patch) | |
| tree | 429a1a63db4e5a722de2ac1aeb699bc43e375570 /phpBB/phpbb/search/fulltext_postgres.php | |
| parent | 2a6c9233e9667143f8d105b54c5cdb41b5a9e686 (diff) | |
| parent | d05c7fd34288375683c5b0467930748b1457ac75 (diff) | |
| download | forums-f26b2c00de5702403e3c5983dedf99ac6dc06d8c.tar forums-f26b2c00de5702403e3c5983dedf99ac6dc06d8c.tar.gz forums-f26b2c00de5702403e3c5983dedf99ac6dc06d8c.tar.bz2 forums-f26b2c00de5702403e3c5983dedf99ac6dc06d8c.tar.xz forums-f26b2c00de5702403e3c5983dedf99ac6dc06d8c.zip | |
Merge pull request #5076 from marc1706/ticket/15496
[ticket/15496] Add sort key to SELECT in fulltext_postgres
Diffstat (limited to 'phpBB/phpbb/search/fulltext_postgres.php')
| -rw-r--r-- | phpBB/phpbb/search/fulltext_postgres.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/phpBB/phpbb/search/fulltext_postgres.php b/phpBB/phpbb/search/fulltext_postgres.php index 4fe7e3b88d..6443342057 100644 --- a/phpBB/phpbb/search/fulltext_postgres.php +++ b/phpBB/phpbb/search/fulltext_postgres.php @@ -498,7 +498,7 @@ class fulltext_postgres extends \phpbb\search\base ); extract($this->phpbb_dispatcher->trigger_event('core.search_postgres_keywords_main_query_before', compact($vars))); - $sql_select = ($type == 'posts') ? 'p.post_id' : 'DISTINCT t.topic_id'; + $sql_select = ($type == 'posts') ? 'p.post_id' : 'DISTINCT t.topic_id, ' . $sort_by_sql[$sort_key]; $sql_from = ($join_topic) ? TOPICS_TABLE . ' t, ' : ''; $field = ($type == 'posts') ? 'post_id' : 'topic_id'; |