[GENERAL] RETURN QUERY SELECT & TYPE

[screamge]

Here is code of first procedure:

CREATE TYPE some_item AS
(id integer,
title character varying,
...
);


CREATE OR REPLACE FUNCTION some_func (integer) RETURNS some_item AS
...
itemid ALIAS for $1;
resulter some_item%rowtype;

...
SELECT INTO resulter
n_id, t_title FROM some_table WHERE n_id = itemid;
RETURN resulter;



I want to call some_func from another procedure and get result set of
some_items type. Something like this:


CREATE OR REPLACE FUNCTION other_func (integer) RETURNS SETOF some_item AS
...
RETURN QUERY SELECT some_func(id) FROM another_table;
;


But when i run other_func i get:

ERROR: structure of query does not match function result type