Advertisement
Guest User

Untitled

a guest
Jun 21st, 2017
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.54 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION test1(text) returns returntype AS
  2. $_$
  3. DECLARE
  4. r returntype%ROWTYPE;
  5. roz int;
  6. pass text;
  7. BEGIN
  8.  BEGIN
  9.   SELECT  id  FROM koncowki WHERE mac = $1::macaddr limit 1 INTO roz;
  10.  EXCEPTION
  11.   SELECT  id,password  FROM koncowki WHERE login = $1 limit 1 INTO roz,pass;
  12.  END;
  13.  IF NOT FOUND
  14.    RETURN r;
  15.  END IF;
  16.  
  17.  IF (roz = 0)
  18.    THEN RETURN r;
  19.  END IF;
  20.  
  21.   r.id := roz;
  22.   r.username := $1;
  23.   r.attribute := 'Cleartext-Password';
  24.   r.op := ':=';
  25.   r.VALUE := pass;
  26.  
  27.   RETURN r;
  28. END;
  29. $_$ LANGUAGE 'plpgpsql'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement