954
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE FUNCTION studentquery(
qname character varying,
qdate character varying)
RETURNS SETOF student AS
$$
BEGIN
IF name = '' THEN
RETURN QUERY SELECT * FROM student WHERE createdate=qdate;
END IF;
RETURN QUERY SELECT * FROM student WHERE createdate=qdate AND name=qname;;
END
$$
LANGUAGE plpgsql;