X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2F20%2Fupdate_buffer_lastseen.sql;h=14e5c58d11d931aa28128cfa5b7bb9cd4e67438b;hp=98218a641afa04497caebd4abd039bdb432dda6f;hb=5e3bcda8c341dbe6846d4723afe7096acca8f304;hpb=8af0ba8424957091f3b661e9f52b787681f0a51d;ds=sidebyside diff --git a/src/core/SQL/PostgreSQL/20/update_buffer_lastseen.sql b/src/core/SQL/PostgreSQL/20/update_buffer_lastseen.sql index 98218a64..14e5c58d 100644 --- 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 = min(:lastseenmsgid, buffer.lastmsgid) +SET lastseenmsgid = least(:lastseenmsgid, buffer.lastmsgid) WHERE userid = :userid AND bufferid = :bufferid