From 85a1f20681b4f28b7e5230ef64c2b59e178ce638 Mon Sep 17 00:00:00 2001 From: Michael McVady Date: Fri, 12 Jan 2024 17:26:24 -0600 Subject: Flesh out 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 a55fafb..7fbe898 100644 --- a/src/queries.h +++ b/src/queries.h @@ -11,13 +11,13 @@ const char *q_select_entries = const char *q_search_entries = "WITH query AS " "( " -" SELECT id, title, created_at::DATE, updated_at::DATE, " +" SELECT id, title, created_at::DATE, updated_at::DATE, body, " " TS_RANK(search_vector, TO_TSQUERY('english', $1)) AS rank " " FROM entries " " WHERE search_vector @@ TO_TSQUERY('english', $2) " " ORDER BY rank DESC " ") " -"SELECT id, title, created_at::DATE, updated_at::DATE FROM query;"; +"SELECT id, title, created_at::DATE, updated_at::DATE, body FROM query;"; const char *q_update_entry = "UPDATE entries " -- cgit v1.2.3