Changes between Initial Version and Version 1 of Ticket #35793, comment 4


Ignore:
Timestamp:
Oct 23, 2024, 12:56:04 PM (4 weeks ago)
Author:
Simon Charette

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #35793, comment 4

    initial v1  
    1717{{{#!sql
    1818INSERT 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
     19ON CONFLICT (post_id, user_id)
     20DO UPDATE SET count = postview.count + 1 -- Or should it be count = excluded.count + 1?
    2021}}}
    2122
Back to Top