diff options
| author | Michael McVady <femtonaut@gmail.com> | 2024-01-13 14:24:21 -0600 |
|---|---|---|
| committer | Michael McVady <femtonaut@gmail.com> | 2024-01-13 14:24:21 -0600 |
| commit | 193279017ac7da417f72c2073372204fd881ef70 (patch) | |
| tree | ce71047731490496b794c037e2ed8520b386adca | |
| parent | 5a3489865fa7efe40eaa59a4ca865387b25f0d35 (diff) | |
Order index
| -rw-r--r-- | src/queries.h | 2 |
1 files changed, 1 insertions, 1 deletions
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 " |