From 660d6e73218229c6ac08ac2b7a19819169529fc8 Mon Sep 17 00:00:00 2001
From: Michael McVady <femtonaut@gmail.com>
Date: Fri, 12 Jan 2024 16:02:15 -0600
Subject: Start implementing search

---
 src/queries.h | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'src/queries.h')

diff --git a/src/queries.h b/src/queries.h
index 1246091..f406434 100644
--- a/src/queries.h
+++ b/src/queries.h
@@ -24,8 +24,8 @@ const char *q_select_entries =
 
 const char *q_update_entry =
 "UPDATE entries "
-"SET title = $1, body = $2, updated_at = NOW() "
-"WHERE id = $3 "
+"SET title = $1, body = $2, updated_at = NOW(), search_vector = TO_TSVECTOR('english', $3) "
+"WHERE id = $4 "
 "RETURNING id;";
 
 // const char *q_delete_entry =
-- 
cgit v1.2.3