1 CREATE OR REPLACE FUNCTION populate_lastmsgid() RETURNS void AS $$
5 FOR i IN SELECT * FROM buffer
8 SET lastmsgid = COALESCE((
9 SELECT backlog.messageid
11 WHERE backlog.bufferid = i.bufferid
12 ORDER BY messageid DESC LIMIT 1
14 WHERE buffer.bufferid = i.bufferid;