CREATE OR REPLACE FUNCTION user_load_by_email(p_email text)
  RETURNS refcursor AS
$BODY$
DECLARE
  l_res REFCURSOR;
BEGIN
    l_res := 'cur';
    OPEN l_res
    FOR
		SELECT * 
        	--id, email, password, first_name, last_name, status
	   	FROM users
	   	WHERE email = p_email;
    RETURN l_res;
END;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE
  COST  100 ;
ALTER FUNCTION user_load_by_email(text) OWNER TO postgres;
GRANT EXECUTE ON FUNCTION user_load_by_email(text) TO public;
GRANT EXECUTE ON FUNCTION user_load_by_email(text) TO postgres;

CREATE OR REPLACE FUNCTION user_load_by_email(p_email text)
  RETURNS refcursor AS
$BODY$
DECLARE
  l_res REFCURSOR;
	conn text;
BEGIN
	
    l_res := 'cur';
    conn := 'SELECT user_load_by_email('''||p_email||''')';  
    OPEN l_res
    FOR
	SELECT * FROM dblink((SELECT str FROM "ConnStr"),conn) as t1(id bigint,
	email character varying( 320 ),
	"password" character varying( 32 ),
	first_name character varying( 50 ),
	last_name character varying( 50 ),
	status smallint, -- 0 - non-registered - virtual...
	patronymic character varying( 50 ),
	birthday date);
    RETURN l_res;
END;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE
  COST  100 ;
ALTER FUNCTION user_load_by_email(text) OWNER TO postgres;
GRANT EXECUTE ON FUNCTION user_load_by_email(text) TO public;
GRANT EXECUTE ON FUNCTION user_load_by_email(text) TO postgres;