X-Git-Url: https://git.quassel-irc.org/?a=blobdiff_plain;f=src%2Fcore%2FSQL%2FSQLite%2F9%2Fselect_messagesSinceOffset.sql;fp=src%2Fcore%2FSQL%2FSQLite%2F9%2Fselect_messagesSinceOffset.sql;h=65f2cc21f79f0103c8a4ae5d745f4425b3ba7bef;hb=cd0868fff76dd067470881134fd736e1a1d97e71;hp=0000000000000000000000000000000000000000;hpb=0b6fe99dce6a20245721a0d826925e1186dc4d04;p=quassel.git diff --git a/src/core/SQL/SQLite/9/select_messagesSinceOffset.sql b/src/core/SQL/SQLite/9/select_messagesSinceOffset.sql new file mode 100644 index 00000000..65f2cc21 --- /dev/null +++ b/src/core/SQL/SQLite/9/select_messagesSinceOffset.sql @@ -0,0 +1,3 @@ +SELECT count(*) +FROM backlog +WHERE bufferid = :bufferid AND time >= :since