PostgreSQL stynax error creating function

Question

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

Craig Ringer · Accepted Answer · 2014-07-18 08:46:24Z

2

You're trying to use PL/PgSQL syntax in an SQL function. You also forgot the semicolon on the end of the SELECT.

Declare it LANGUAGE plpgsql. Or, as the function is so trivial, just turn it into valid sql function syntax by replacing the body with:

$BODY$
SELECT name * FROM (documents) where id=p_docId;
$BODY$

though the SQL statement its self is also invalid - name *?

answered Jul 18, 2014 at 8:46

Craig Ringer

329k84 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Craig Ringer Over a year ago

@Jacob That's because that SQL is invalid. What are you trying to write? name * FROM ... makes no sense.

Collectives™ on Stack Overflow

PostgreSQL stynax error creating function

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related