Re: What is made a mistake with SP?

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Marcos <mjs_ops(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: What is made a mistake with SP?
Date: 2006-01-23 16:27:24
Message-ID: 61D888E7-6A79-48BD-BDF1-E577D28AAA3D@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 2006-01-23 16:52:45 Re: RAID 5 and postgresql
Previous Message Tom Lane 2006-01-23 16:05:23 Re: invalid memory alloc request size