projects
/
quassel.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
| inline |
side by side
Merge pull request #273 from ReimuHakurei/master
[quassel.git]
/
src
/
core
/
SQL
/
PostgreSQL
/
20
/
update_buffer_lastseen.sql
diff --git
a/src/core/SQL/PostgreSQL/20/update_buffer_lastseen.sql
b/src/core/SQL/PostgreSQL/20/update_buffer_lastseen.sql
index
5541505
..
98218a6
100644
(file)
--- a/
src/core/SQL/PostgreSQL/20/update_buffer_lastseen.sql
+++ b/
src/core/SQL/PostgreSQL/20/update_buffer_lastseen.sql
@@
-1,3
+1,3
@@
UPDATE buffer
-SET lastseenmsgid =
:lastseenmsgid
+SET lastseenmsgid =
min(:lastseenmsgid, buffer.lastmsgid)
WHERE userid = :userid AND bufferid = :bufferid