Guest User

Untitled

a guest
May 21st, 2018
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION public.firefunc()
  2. RETURNS trigger
  3. LANGUAGE 'plpgsql'
  4. VOLATILE
  5. COST 100
  6. AS $BODY$ BEGIN
  7. 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);
  8. into jharkhandfire
  9. from public.vnp14imgtdl_nrt_global_24h
  10. where st_intersects(new.geom, states.geom);
  11. RETURN NEW;
  12. END;
  13. $BODY$;
Add Comment
Please, Sign In to add comment