X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2Fsetup_061_add_function_backlog_lastmsgid_update.sql;fp=src%2Fcore%2FSQL%2FPostgreSQL%2Fsetup_061_add_function_backlog_lastmsgid_update.sql;h=9b96b4a61ee5c9afbff2273cdde4d8b5abfc86be;hp=0000000000000000000000000000000000000000;hb=1d1178f7d73ab19e62798f23c1d0cd5e0b4cdb59;hpb=3cf5c49e7753be48a994917fe898730add4292b1

diff --git a/src/core/SQL/PostgreSQL/setup_061_add_function_backlog_lastmsgid_update.sql b/src/core/SQL/PostgreSQL/setup_061_add_function_backlog_lastmsgid_update.sql
new file mode 100644
index 00000000..9b96b4a6
--- /dev/null
+++ b/src/core/SQL/PostgreSQL/setup_061_add_function_backlog_lastmsgid_update.sql
@@ -0,0 +1,12 @@
+CREATE OR REPLACE FUNCTION public.backlog_lastmsgid_update()
+RETURNS trigger
+AS $BODY$
+    BEGIN
+        UPDATE buffer
+        SET lastmsgid = new.messageid
+        WHERE buffer.bufferid = new.bufferid
+            AND buffer.lastmsgid < new.messageid;
+        RETURN new;
+    END
+$BODY$
+LANGUAGE plpgsql;