X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A6B5F5E3639 for ; Sat, 21 Aug 2004 11:42:00 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 24181-01 for ; Sat, 21 Aug 2004 14:41:57 +0000 (GMT) Received: from hotmail.com (bay17-dav9.bay17.hotmail.com [64.4.43.189]) by svr1.postgresql.org (Postfix) with ESMTP id 465835E46C1 for ; Sat, 21 Aug 2004 11:41:54 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Sat, 21 Aug 2004 07:34:54 -0700 Received: from 61.1.50.211 by bay17-dav9.bay17.hotmail.com with DAV; Sat, 21 Aug 2004 14:04:24 +0000 X-Originating-IP: [61.1.50.211] X-Originating-Email: [themajolee@hotmail.com] X-Sender: themajolee@hotmail.com From: "Majolee InfoTech (Hotmail)" To: Subject: Dynamic Record Type Field Names Date: Sat, 21 Aug 2004 19:40:12 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0141_01C487B6.ACE12390" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Message-ID: X-OriginalArrivalTime: 21 Aug 2004 14:34:54.0293 (UTC) FILETIME=[063B3050:01C4878C] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=HTML_40_50, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200408/38 X-Sequence-Number: 2926 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=20=20=20=20=20 Partners=20=20=20=20=20=20=20=20=20=20=20=20=20 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
 
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=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Mihir & Biren=     =20
Partners          &nb= sp; =20
Majolee InfoTech
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
------=_NextPart_000_0141_01C487B6.ACE12390--