From 72960ddc9cc7844f1dc3419ead0842df61213ba8 Mon Sep 17 00:00:00 2001 From: Michael McVady Date: Sat, 30 Dec 2023 21:09:09 -0600 Subject: Just keep hacking --- src/queries.h | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'src/queries.h') 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) " -- cgit v1.2.3