Re: What is made a mistake with SP?

[John DeSoi <desoi@xxxxxxxxxx>]

On Jan 23, 2006, at 8:34 AM, Marcos wrote:

> ERROR: type "tipo_compras_calculado" not exists.

You have a set returning function (RETURNS setof  
tipo_compras_calculado), so this means you need to declare this type.  
So you should have a CREATE TYPE statement somewhere which defines  
the fields of tipo_compras_calculado. Something like:

CREATE TYPE tipo_compras_calculado (
	id text,
	produto integer,
...
);


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL