From 89f20b0ff36c8413adc2aa9e3c5226ae2eed2101 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Fri, 3 Feb 2023 06:39:25 +0300
Subject: messages_txt -> messages

---
 src/main/java/com/juick/service/PostgresSearchService.java | 8 ++------
 1 file changed, 2 insertions(+), 6 deletions(-)

(limited to 'src/main/java/com/juick/service/PostgresSearchService.java')

diff --git a/src/main/java/com/juick/service/PostgresSearchService.java b/src/main/java/com/juick/service/PostgresSearchService.java
index 500f3d20..2493a45e 100644
--- a/src/main/java/com/juick/service/PostgresSearchService.java
+++ b/src/main/java/com/juick/service/PostgresSearchService.java
@@ -70,14 +70,10 @@ public class PostgresSearchService extends BaseJdbcService implements SearchServ
                                   FROM
                                     (
                                       select
-                                        messages.message_id message_id,
-                                        messages.user_id user_id,
-                                        txt,
+                                        message_id,  user_id, txt,
                                         to_tsvector('russian', txt) v,
                                         websearch_to_tsquery('russian', :query) q
-                                      from
-                                        messages_txt
-                                        inner join messages on messages.message_id = messages_txt.message_id
+                                      from messages
                                     ) t
                                   WHERE
                                     v @@ q
-- 
cgit v1.2.3