"Jaime Casanova" <[EMAIL PROTECTED]> 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

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to