I am creating a function in my PostgreSQL but I'm getting this syntax error and I ran out of ideas what could be wrong... Please assist.
CREATE OR REPLACE FUNCTION get_docName(IN p_docId_id bigint)
RETURNS TABLE(name varchar) AS
$BODY$
begin
RETURN query SELECT name * FROM (documents) where id=p_docId
end;
$BODY$
LANGUAGE sql STABLE;
ALTER FUNCTION public.get_documents(IN bigint)
OWNER TO postgres;
Errors:
ERROR: SyntaxError at „RETURN“
LINE 8: RETURN query SELECT * FROM (
^
********** Error **********
ERROR: SyntaxError at „RETURN“
SQL state: 42601
Character: 173