Received: from chennai.transys (chennai.transys.net [12.33.140.105]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g04EsDm62899 for ; Fri, 4 Jan 2002 09:54:15 -0500 (EST) (envelope-from unnikrishnan.menon@chennai.transys.net) Received: from UNNIKRISHNAN ([192.168.10.233]) by chennai.transys with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21) id CGH4XZYQ; Fri, 4 Jan 2002 20:36:42 +0530 Message-ID: <008501c1952f$f00ed530$e90aa8c0@UNNIKRISHNAN> From: "Unnikrishnan Menon" To: Subject: Execute dynamically generated query??? Date: Fri, 4 Jan 2002 20:25:58 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0082_01C1955E.053490C0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 Disposition-Notification-To: "Unnikrishnan Menon" X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200201/33 X-Sequence-Number: 6124 This is a multi-part message in MIME format. ------=_NextPart_000_0082_01C1955E.053490C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I am new to PostgreSQL and wish to do the following: 1. I am trying to execute a dynamically generated query within a function -= Create table tablename as Select expressions .. from tablename, tablename = where ......=20=20=20=20=20 The function on execution gives the following error: Select ....into is= not yet implemented. Could anyone help me with a workaround for the functi= on to be executed. 2. Select count(*) count from tab; The following query gives the error Relation tab does not exists. Throu= gh documents i understand that it is not possible to use the above query. H= as anybody tried a=20 workaround process for the above. Any help would be welcome, Thanx in advance, Unnikrishnan Menon. ------=_NextPart_000_0082_01C1955E.053490C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
 
I am new to PostgreSQL and wish to do the= =20 following:
 
1. I am trying to execute a dynamically ge= nerated=20 query within a function - Create table tablename as Select expressions .. f= rom=20 tablename, tablename where ......    
    The function on ex= ecution=20 gives the following error: Select ....into is not yet implemented. Could an= yone=20 help me with a workaround for the function to be executed.
 
2. Sele= ct count(*)=20 count from tab;
    The following query giv= es the=20 error Relation tab does not exists. Through documents i understan= d=20 that it is not possible to use the above query. Has anybody tried a=20
    workaround process for = the=20 above.
 
Any help would be welcome,
 
Thanx in advance,
 
Unnikrishnan Menon.
------=_NextPart_000_0082_01C1955E.053490C0--