diff options
| author | Michael McVady <femtonaut@gmail.com> | 2024-01-12 17:26:24 -0600 |
|---|---|---|
| committer | Michael McVady <femtonaut@gmail.com> | 2024-01-12 17:26:24 -0600 |
| commit | 85a1f20681b4f28b7e5230ef64c2b59e178ce638 (patch) | |
| tree | e3f45e05890d25e56a6e2f26034c2d65cd4b73db /src/queries.h | |
| parent | dd5411a8d709520c19a2e3577064b6c1bc289e64 (diff) | |
Flesh out search ...
Diffstat (limited to 'src/queries.h')
| -rw-r--r-- | src/queries.h | 4 |
1 files changed, 2 insertions, 2 deletions
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 " |