summaryrefslogtreecommitdiff
path: root/query/messages.sql
diff options
context:
space:
mode:
Diffstat (limited to 'query/messages.sql')
-rw-r--r--query/messages.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/query/messages.sql b/query/messages.sql
index a598754..c345068 100644
--- a/query/messages.sql
+++ b/query/messages.sql
@@ -9,3 +9,10 @@ INSERT INTO messages (
?, ?, ?, ?, ?
)
RETURNING *;
+
+-- name: EditMessage :one
+UPDATE messages SET
+ edited = true,
+ content = ?
+WHERE id = ?
+RETURNING *;