gistfile1.txt

CREATE OR REPLACE FUNCTION SPROC_UA_MSG(_forChan INTEGER, _usr INTEGER, _t TIMESTAMP, _msg TEXT)
RETURNS void AS
$$
DECLARE
	tmprow msg%ROWTYPE;
BEGIN
	-- [error: relation "tmprow" does not exist]
	INSERT INTO msg (forChan,usr,t,msg)
	VALUES(_forChan,_usr,_t,_msg)
	RETURNING *
	INTO tmprow;

	PERFORM pg_notify("msg", row_to_json(rec.*)::TEXT) FROM tmprow AS rec;

	--PERFORM pg_notify("msg", row_to_json(rec.*)::TEXT) FROM (
	--	SELECT _forChan as forChan, _usr as usr, _t as t, _msg as msg
	--) AS rec;
END;
$$
LANGUAGE plpgsql;