daily pastebin goal
41%
SHARE
TWEET

mitteaktiivseks

a guest Dec 13th, 2018 56 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE OR REPLACE FUNCTION f_muuda_laoruum_mitteaktiivseks (p_laoruumi_kood Laoruum.laoruumi_kood%TYPE)
  2. RETURNS VOID AS $$
  3. UPDATE Laoruum SET laoruumi_seisundi_liik_kood=3
  4. WHERE laoruum.laoruumi_kood = p_laoruumi_kood AND laoruum.laoruumi_seisundi_liik_kood = 2
  5. $$ LANGUAGE SQL SECURITY DEFINER
  6. SET search_path=public, pg_temp;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top