CREATE OR REPLACE FUNCTION spgetmatchingusers(IN email text)
RETURNS TABLE(email character, password character, userid smallint, teamname character, reset_password character, reset_password_expiry timestamp with time zone) AS
$BODY$
select "email", "password", "userid", "teamname", "reset_password", "reset_password_expiry"
from "RegisteredUsers"
where LOWER("RegisteredUsers"."email") = LOWER(email)
$BODY$
LANGUAGE sql VOLATILE
COST 100
ROWS 1000;
ALTER FUNCTION spgetmatchingusers(text)
OWNER TO bjlizgykrnyffr;

select * from spgetmatchingusers('user@email.com')

select * from spgetmatchingusers('randomtext')

CREATE TABLE "RegisteredUsers"
(
userid smallint NOT NULL DEFAULT nextval('user_id_seq'::regclass),
teamname character(50) NOT NULL,
first_name character(50),
surname character(50),
email character(50),
company_name character(50),
password character(50),
reset_password character(50),
reset_password_expiry timestamp with time zone,
CONSTRAINT "RegisteredUsers_pkey" PRIMARY KEY (userid)
)
WITH (
OIDS=FALSE
);
ALTER TABLE "RegisteredUsers"
OWNER TO bjlizgykrnyffr;