diff options
| author | Michael McVady <femtonaut@gmail.com> | 2024-01-12 16:02:15 -0600 |
|---|---|---|
| committer | Michael McVady <femtonaut@gmail.com> | 2024-01-12 16:02:15 -0600 |
| commit | 660d6e73218229c6ac08ac2b7a19819169529fc8 (patch) | |
| tree | 7fb2471c2f1161643b9083a9ca0b900834507ecc /src/queries.h | |
| parent | d7f423861facdbf3745988a20f576bbf50d6d381 (diff) | |
Start implementing 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 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 = |