Thread: can we create a record of more than one field?

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

"Jaime Casanova" <jcasanov@systemguards.com.ec> writes:
> 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

It's not a record, it's an integer... if you had more than one out
parameter then "record" would be sensible ...
        regards, tom lane