This is a multi-part message in MIME format.
------=_NextPart_000_0141_01C487B6.ACE12390
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello,
We are using a Postgresql 7.4 DB.
We need a function in pl/pgsql which will return a delimited text based dat=
a from a table where table name is passed as argument.
While trying to loop through using "For record In Execute query Loop" we ca=
n not use field names for geting a specific filed value.
So we are finding other ways to get data from record and append it to a str=
ing.
We tried using a dynamic function generation where we pass the record to th=
at function but there seems to be some error when passing record to a recen=
tly generated function.
Any help would be great.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Mihir & Biren
Partners
Majolee InfoTech
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
------=_NextPart_000_0141_01C487B6.ACE12390
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1458" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DTahoma size=3D2></FONT> </DIV>
<DIV><FONT face=3DTahoma size=3D2>Hello,</FONT></DIV>
<DIV><FONT face=3DTahoma size=3D2></FONT> </DIV>
<DIV><FONT face=3DTahoma size=3D2>We are using a Postgresql 7.4 DB.</FONT><=
/DIV>
<DIV><FONT face=3DTahoma size=3D2></FONT> </DIV>
<DIV><FONT face=3DTahoma size=3D2>We need a function in pl/pgsql which will=
return a
delimited text based data from a table where table name is passed as
argument.</FONT></DIV>
<DIV><FONT face=3DTahoma size=3D2></FONT> </DIV>
<DIV><FONT face=3DTahoma size=3D2>While trying to loop through using "For r=
ecord In
Execute query Loop" we can not use field names for geting a specific filed=
value.</FONT></DIV>
<DIV><FONT face=3DTahoma size=3D2></FONT> </DIV>
<DIV><FONT face=3DTahoma size=3D2>So we are finding other ways to get data =
from
record and append it to a string.</FONT></DIV>
<DIV><FONT face=3DTahoma size=3D2></FONT> </DIV>
<DIV><FONT face=3DTahoma size=3D2>We tried using a dynamic function generat=
ion where
we pass the record to that function but there seems to be some error when=
passing record to a recently generated function.</FONT></DIV>
<DIV><FONT face=3DTahoma size=3D2></FONT> </DIV>
<DIV><FONT face=3DTahoma size=3D2>Any help would be great.</DIV>
<DIV><BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR>Mihir & Biren=
<BR>Partners &nb=
sp;
<BR>Majolee InfoTech<BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT=
></DIV></BODY></HTML>
------=_NextPart_000_0141_01C487B6.ACE12390--
