From 193279017ac7da417f72c2073372204fd881ef70 Mon Sep 17 00:00:00 2001 From: Michael McVady Date: Sat, 13 Jan 2024 14:24:21 -0600 Subject: Order index --- src/queries.h | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'src/queries.h') diff --git a/src/queries.h b/src/queries.h index 7fbe898..9e90581 100644 --- a/src/queries.h +++ b/src/queries.h @@ -6,7 +6,7 @@ const char *q_select_entry = const char *q_select_entries = "SELECT id, title, created_at::DATE, updated_at::DATE, body " "FROM entries " -"ORDER BY updated_at DESC;"; +"ORDER BY updated_at DESC, created_at DESC;"; const char *q_search_entries = "WITH query AS " -- cgit v1.2.3