FUNCTION ERROR - Mailing list pgsql-sql

From Mario Alberto Soto Cordones
Subject FUNCTION ERROR
Date
Msg-id 1786.192.168.1.100.1051046246.squirrel@www.compuall.cl
Whole thread Raw
Responses Re: FUNCTION ERROR  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
Hi.
i have a big problem with a function.

i create a type unidades   CREATE TYPE unidades AS (codigo numeric(3,0),                            descripcion text);
and i create a function get_unidades    CREATE FUNCTION get_unidades(int4, int4, int4, int4) RETURNStypeofunidades AS
'SELECTcucoduni, cudesuniFROM cumauniWHERE cuempuni = $1 and      cuseduni = $2 and      cucaruni = $3 and
cuasiuni=$4; '  LANGUAGE 'sql'; 

when execute this function

select * from get_contenidos(10,1,15,17,31,12)
as (codigo numeric(3,0),
descripcion text)

SAY

ERROR: ExecMakeTableFunctionResult: Invalid result from function returning
tuple

ANY IDEA



pgsql-sql by date:

Previous
From: "A.Bhuvaneswaran"
Date:
Subject: Re: trouble creating trigger
Next
From: Stephan Szabo
Date:
Subject: Re: FUNCTION ERROR