Dynamic Record Type Field Names
am 21.08.2004 16:10:12 von themajoleeThis 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
Mihir & Biren =20
Partners =20
Majolee InfoTech
===============3D
------=_NextPart_000_0141_01C487B6.ACE12390
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
/DIV>
return a=20
delimited text based data from a table where table name is passed as=20
argument.
ecord In=20
Execute query Loop" we can not use field names for geting a specific filed=
=20
value.
from=20
record and append it to a string.
ion where=20
we pass the record to that function but there seems to be some error when=
=20
passing record to a recently generated function.
===============3D
Mihir & Biren=
=20
Partners &nb=
sp; =20
Majolee InfoTech
===============3D >
------=_NextPart_000_0141_01C487B6.ACE12390--