shahidhk · August 28, 2018 11:39
diff --git a/realtime-poll-user-online-trigger.sql b/realtime-poll-user-online-trigger.sql
 CREATE FUNCTION update_last_seen_timestamp_func() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
      BEGIN
          NEW.last_seen_at := now();
          RETURN NEW;
      END;
  $$;
  
 CREATE TRIGGER update_last_seen_timestamp_trigger 
  BEFORE INSERT OR UPDATE ON "user" FOR EACH ROW
  EXECUTE PROCEDURE update_last_seen_timestamp_func();
	CREATE FUNCTION update_last_seen_timestamp_func() RETURNS trigger
	LANGUAGE plpgsql
	AS $$
	BEGIN
	NEW.last_seen_at := now();
	RETURN NEW;
	END;
	$$;

	CREATE TRIGGER update_last_seen_timestamp_trigger
	BEFORE INSERT OR UPDATE ON "user" FOR EACH ROW
	EXECUTE PROCEDURE update_last_seen_timestamp_func();
No results found