diff options
| author | Michael McVady <femtonaut@gmail.com> | 2023-12-30 21:09:09 -0600 |
|---|---|---|
| committer | Michael McVady <femtonaut@gmail.com> | 2023-12-30 21:09:09 -0600 |
| commit | 72960ddc9cc7844f1dc3419ead0842df61213ba8 (patch) | |
| tree | d10e1071fa4a3167b657769be1d4ec67ced7264b /src/queries.h | |
| parent | 212bd22001b24023a72342fd17a04a4cc24ae305 (diff) | |
Just keep hacking
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) " |