Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION public.firefunc()
- RETURNS trigger
- LANGUAGE 'plpgsql'
- VOLATILE
- COST 100
- AS $BODY$ BEGIN
- select(new.gid, new.latitude, new.longitude, new.bright_ti4, new.scan, new.track, new.acq_date, new.acq_time, new.satellite, new.confidence, new.version, new.bright_ti5, new.frp, new.daynight, new.geom);
- into jharkhandfire
- from public.vnp14imgtdl_nrt_global_24h
- where st_intersects(new.geom, states.geom);
- RETURN NEW;
- END;
- $BODY$;
Add Comment
Please, Sign In to add comment