summaryrefslogtreecommitdiff
path: root/query/notifications.sql
blob: 5dd4d5a18fc2e843e1ac7d36a4e52315d1c5ee9a (plain)
1
2
3
4
5
6
7
-- name: SetLastReadMessage :exec
INSERT INTO last_read_messages (
  user_id, source_id, last_read
) VALUES (?, ?, ?)
ON CONFLICT DO
UPDATE SET last_read = EXCLUDED.last_read
WHERE user_id = EXCLUDED.user_id AND source_id = EXCLUDED.source_id;