Changes between Initial Version and Version 1 of Ticket #35793, comment 4
- Timestamp:
- Oct 23, 2024, 12:56:04 PM (3 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #35793, comment 4
initial v1 17 17 {{{#!sql 18 18 INSERT INTO postview(post_id, user_id, count) VALUES(:post_id, :user_id, :count) 19 ON CONFLICT (post_id, user_id) DO UPDATE SET count = postview.update + 1 19 ON CONFLICT (post_id, user_id) 20 DO UPDATE SET count = postview.count + 1 -- Or should it be count = excluded.count + 1? 20 21 }}} 21 22