[SQL] ERROR: unexpected SELECT query in exec_stmt_execsql()

[Branden R. Williams]

Hi.  I am attempting to create a function to do some selects and return
some information.  Pretty straight forward.  No matter what I do, I always
get this error.  Here is my stored function and how I am calling it...

create function sp_list_categories(int4) returns varchar as '
DECLARE
        postid ALIAS FOR $1;
        parentid int4;
BEGIN

        SELECT * FROM category WHERE id = postid;
        parentid := SELECT parent FROM category WHERE id = postid;

        IF parentid ISNULL THEN
                RETURN
        ELSE
                SELECT sp_list_categories(parentid);
                RETURN name;
        END IF;

END;
' LANGUAGE 'plpgsql';


jimmydbase=# select sp_list_categories(20);
ERROR:  unexpected SELECT query in exec_stmt_execsql()

Any and all help would be appreciated!

Branden.