jhu_trigger_func.sql

CREATE OR REPLACE FUNCTION public.jhu_county_watched()
  RETURNS trigger AS
$BODY$
DECLARE
BEGIN
  PERFORM pg_notify('jhucounty', '{"type": "Feature", "geometry": ' || 
	st_asgeojson(NEW.wkb_geometry) || 
	',"properties": {"message": "' || 
	'update' || '",' ||
	'"fips": "' || NEW.fips || '",' ||
	'"label": "' || NEW.combined_key || '",' ||
	'"confirmed": "' || NEW.confirmed || '",' ||
	'"last_update": "' || NEW.last_update || '"' ||
	'}}' );
  RETURN new;
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION public.jhu_county_watched()
  OWNER TO postgres;