can we create a record of more than one field?

From: "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: can we create a record of more than one field?
Date: 2008-10-31 05:18:08
Message-ID: 3073cc9b0810302218g2ffc4c38g99137b40cc667a98@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

in the spanish list someone reports that the following function
doesn't even compile:

CREATE FUNCTION select_temporal(OUT valor integer) RETURNS SETOF record AS
$BODY$
begin
return query select 1::integer;
return;
end;
$BODY$
LANGUAGE 'plpgsql' VOLATILE;

and this is the error message
ERROR: function result type must be integer because of OUT parameters

i was expecting the result to be a record because of the SETOF record.
it's a bug or intentional?

this is in 8.3.4

--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-10-31 05:29:05 Re: can we create a record of more than one field?
Previous Message Kyle Cordes 2008-10-31 04:32:59 Re: Decreasing WAL size effects