diff options
Diffstat (limited to 'src/queries.h')
| -rw-r--r-- | src/queries.h | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/src/queries.h b/src/queries.h index 986f180..c0bd1dc 100644 --- a/src/queries.h +++ b/src/queries.h @@ -8,6 +8,11 @@ const char *q_select_entries = "FROM entries " "ORDER BY updated_at DESC;"; +const char *q_select_index = +"SELECT id, title, created_at::DATE, updated_at::DATE " +"FROM entries " +"ORDER BY updated_at DESC;"; + const char *q_insert_entry = "INSERT INTO entries " "(title, body) " |