[Pgsql-ayuda] plpgsql que tipo de dato es un recordset para una function
Fernando Papa
fpapa@claxson.com
Mon, 23 Jun 2003 17:42:41 -0300
This is a multi-part message in MIME format.
------_=_NextPart_001_01C339C7.FDFA68EC
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
=20
tenes que devolver
=20
RETURNS setof <tabla|vista>
=20
si no me equivoco...
--
Fernando O. Papa
DBA
=20
-----Mensaje original-----
De: Sergio Cisternas [mailto:scisternas@yx.cl]=20
Enviado el: jueves, 19 de junio de 2003 17:57
Para: Pgsql-ayuda@tlali.iztacala.unam.mx
Asunto: [Pgsql-ayuda] plpgsql que tipo de dato es un recordset para una
function
hola alguen podria decirme que tipo de dato debe delvolver
un functon si quieres entregar un recordset
=20
create o replace function hola(int) returns ?? as=20
' declare
xxx alias for $1 ;
rs ???;
begin=20
if xxx>0 then
rs :=3D(select * from xx where id_xx=3Dxxx);
else
rs:=3D (select * from xx);
end if ;
return rs;
end '
language 'plpgsql' ;
=20
Gracias
=20
------_=_NextPart_001_01C339C7.FDFA68EC
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<TITLE>Mensaje</TITLE>
<META content=3D"MSHTML 6.00.2716.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D469014220-23062003>tenes=20
que devolver</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D469014220-23062003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D469014220-23062003>RETURNS setof =
<tabla|vista></SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D469014220-23062003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D469014220-23062003>si no=20
me equivoco...</SPAN></FONT></DIV><!-- Converted from text/plain format =
-->
<P><FONT size=3D2>--<BR>Fernando O. Papa<BR>DBA<BR> </FONT> </P>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px =
solid; MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=3DOutlookMessageHeader lang=3Des dir=3Dltr =
align=3Dleft><FONT face=3DTahoma=20
size=3D2>-----Mensaje original-----<BR><B>De:</B> Sergio Cisternas=20
[mailto:scisternas@yx.cl] <BR><B>Enviado el:</B> jueves, 19 de junio =
de 2003=20
17:57<BR><B>Para:</B> =
Pgsql-ayuda@tlali.iztacala.unam.mx<BR><B>Asunto:</B>=20
[Pgsql-ayuda] plpgsql que tipo de dato es un recordset para una=20
function<BR><BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>hola alguen podria decirme que tipo =
de dato debe=20
delvolver</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>un functon si quieres entregar un=20
recordset</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>create o replace function hola(int) =
returns ?? as=20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>' declare</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>xxx alias for $1 =
;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>rs ???;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>begin </FONT></DIV>
<DIV><FONT face=3DArial size=3D2> if xxx>0 =
then</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> =
rs=20
:=3D(select * from xx where id_xx=3Dxxx);</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> else</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> =
rs:=3D=20
(select * from xx);</FONT></DIV>
<DIV><FONT face=3DArial size=3D2> end if =
;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>return rs;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>end '</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>language 'plpgsql' ;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Gracias</FONT></DIV>
<DIV><FONT face=3DArial =
size=3D2></FONT> </DIV></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C339C7.FDFA68EC--