Re: What is made a mistake with SP? - Mailing list pgsql-general

From John DeSoi
Subject Re: What is made a mistake with SP?
Date
Msg-id 61D888E7-6A79-48BD-BDF1-E577D28AAA3D@pgedit.com
Whole thread Raw
In response to Re: What is made a mistake with SP?  (Marcos <mjs_ops@gmx.net>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: invalid memory alloc request size
Next
From: "Praveen Kumar (TUV)"
Date:
Subject: Full Text Indexing Using Tsearch2-Module