Dynamic Record Type Field Names

Dynamic Record Type Field Names

am 21.08.2004 16:10:12 von themajolee

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
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








 

Hello,

 

We are using a Postgresql 7.4 DB.<=
/DIV>
 

We need a function in pl/pgsql which will=
return a=20
delimited text based data from a table where table name is passed as=20
argument.

 

While trying to loop through using "For r=
ecord In=20
Execute query Loop" we can not use field names for geting a specific filed=
=20
value.

 

So we are finding other ways to get data =
from=20
record and append it to a string.

 

We tried using a dynamic function generat=
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.

 

Any help would be great.


===============3D
Mihir & Biren=
    =20

Partners          &nb=
sp; =20

Majolee InfoTech
===============3D >


------=_NextPart_000_0141_01C487B6.ACE12390--