CREATE OR REPLACE FUNCTION "public"."user_info1" ("log" character varying, "pass" character varying) RETURNS SETOF record AS 'DECLARE
user_id INTEGER;

BEGIN
SELECT id FROM users INTO user_id WHERE login = $1 AND password = md5($2);
IF user_id > 0 THEN
SELECT dblink_connect(''myconn'',''hostaddr=127.0.0.1 dbname=users user=*** password=***'');
RETURN QUERY SELECT * FROM users WHERE id = user_id;
END IF;
END;' LANGUAGE "plpgsql" COST 100 ROWS 1000
VOLATILE
CALLED ON NULL INPUT
SECURITY INVOKER

PERFORM dblink_connect('myconn','hostaddr=127.0.0.1 dbname=users user=*** password=***');
SELECT * FROM dblink ('myconn',CONCAT('SELECT name,email FROM users_info WHERE id = ',user_id)) INTO userinfo AS t(name varchar(128),email varchar(64));
RETURN userinfo;