Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE FUNCTION iniciar_sesion(in_usuario character varying, in_password character varying)
- RETURNS
- TABLE
- (
- estado__usuario character varying
- nombre__usuario character varying
- email___usuario character varying
- )
- LANGUAGE plpgsql
- AS $function$
- BEGIN
- RETURN QUERY
- SELECT
- bt_____usuarios.estado__usuario as estado
- bt_____usuarios.nombre__usuario as nombre
- bt_____usuarios.email___usuario as email
- FROM
- bt_____usuarios
- WHERE
- bt_____usuarios.username = in_username AND
- bt_____usuarios.password = in_password
- ;
- END
- $function$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement