diff options
Diffstat (limited to 'internal/db/sql/messages.sql')
| -rw-r--r-- | internal/db/sql/messages.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/internal/db/sql/messages.sql b/internal/db/sql/messages.sql index a59cebe7d..475b23a86 100644 --- a/internal/db/sql/messages.sql +++ b/internal/db/sql/messages.sql @@ -9,6 +9,12 @@ FROM messages WHERE session_id = ? ORDER BY created_at ASC; +-- name: ListMessagesBySessionAfter :many +SELECT * +FROM messages +WHERE session_id = ? AND created_at > ? +ORDER BY created_at ASC; + -- name: CreateMessage :one INSERT INTO messages ( id, |