error

From: "Adeli Rodriguez" <adeli_rodriguez(at)hotmail(dot)com>
To: pgsql-es-ayuda(at)postgresql(dot)org
Subject: error
Date: 2006-04-03 14:08:46
Message-ID: BAY110-F199E46B8CDA4B0A5C2D7E99AD50@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

<html><div style='background-color:'><DIV class=RTE>CREATE OR REPLACE FUNCTION "public"."opc_div" (varchar, varchar, varchar, varchar) RETURNS SETOF varchar AS<BR>$body$<BR>operacion ALIAS FOR $1;<BR>codsede ALIAS FOR $2;<BR>coddiv ALIAS FOR $3;<BR>desdiv ALIAS FOR $4;<BR>registro record;<BR>BEGIN<BR>IF(operacion='consultar') THEN<BR>SELECT cod_div as Código, des_div as Descripción INTO registro FROM division where cod_sed=codsede order by cod_div;<BR>RETURN NEXT registro;<BR>END IF;<BR>RETURN<BR>END;<BR>$body$</DIV>
<DIV class=RTE>ME DA EL SIGUIENTE ERROR</DIV>
<DIV class=RTE>&nbsp;</DIV>
<DIV class=RTE><STRONG>ERROR:&nbsp; set-valued function called in context that cannot accept a set<BR>CONTEXT:&nbsp; PL/pgSQL function "opc_div" line 24 at return next</STRONG></DIV>
<DIV class=RTE><STRONG></STRONG>&nbsp;</DIV>
<DIV class=RTE>por favor si alguien pudiera ayudarme con este error, gracias y disculpen</DIV></div><br clear=all><hr>Excursiones y escapadas a sitios mágicos. <a href="http://g.msn.com/8HMBESES/2734??PS=47575" target="_top">No te lo pierdas en MSN Entretenimiento</a> </html>

Attachment Content-Type Size
unknown_filename text/html 1.1 KB

Responses

  • Re: error at 2006-04-03 14:14:14 from Alvaro Herrera

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Alvaro Herrera 2006-04-03 14:14:14 Re: error
Previous Message Sebastián Villalba 2006-04-03 13:50:24 Re: return varios registros