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


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to