Advertisement
Guest User

Untitled

a guest
Jul 21st, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. CREATE FUNCTION iniciar_sesion(in_usuario character varying, in_password character varying)
  2. RETURNS
  3. TABLE
  4. (
  5. estado__usuario character varying
  6. nombre__usuario character varying
  7. email___usuario character varying
  8. )
  9. LANGUAGE plpgsql
  10. AS $function$
  11. BEGIN
  12.  
  13. RETURN QUERY
  14.  
  15. SELECT
  16. bt_____usuarios.estado__usuario as estado
  17. bt_____usuarios.nombre__usuario as nombre
  18. bt_____usuarios.email___usuario as email
  19. FROM
  20. bt_____usuarios
  21. WHERE
  22. bt_____usuarios.username = in_username AND
  23. bt_____usuarios.password = in_password
  24. ;
  25.  
  26. END
  27. $function$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement