projects
/
quassel.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
core: Add backlog trigger to update lastmsgid
[quassel.git]
/
src
/
core
/
SQL
/
PostgreSQL
/
setup_061_add_function_backlog_lastmsgid_update.sql
1
CREATE OR REPLACE FUNCTION public.backlog_lastmsgid_update()
2
RETURNS trigger
3
AS $BODY$
4
BEGIN
5
UPDATE buffer
6
SET lastmsgid = new.messageid
7
WHERE buffer.bufferid = new.bufferid
8
AND buffer.lastmsgid < new.messageid;
9
RETURN new;
10
END
11
$BODY$
12
LANGUAGE plpgsql;