Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION f_muuda_laoruum_mitteaktiivseks (p_laoruumi_kood Laoruum.laoruumi_kood%TYPE)
- RETURNS VOID AS $$
- UPDATE Laoruum SET laoruumi_seisundi_liik_kood=3
- WHERE laoruum.laoruumi_kood = p_laoruumi_kood AND laoruum.laoruumi_seisundi_liik_kood = 2
- $$ LANGUAGE SQL SECURITY DEFINER
- SET search_path=public, pg_temp;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement