From dpandey@secf.com Thu Apr  14 11:41:40 2005
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 8F5E153734
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 14 Apr 2005 08:41:40 -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 12322-05
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 14 Apr 2005 11:41:34 +0000 (GMT)
Received: from secf.com (209-128-104-244.bayarea.net [209.128.104.244])
	by svr1.postgresql.org (Postfix) with ESMTP id C840B53726
	for <pgsql-sql@postgresql.org>; Thu, 14 Apr 2005 08:41:31 -0300 (ADT)
Received: from dinesh by secf.com (MDaemon.PRO.v7.2.2.R)
	with ESMTP id md50000632816.msg
	for <pgsql-sql@postgresql.org>; Thu, 14 Apr 2005 04:40:32 -0700
Reply-To: <dpandey@secf.com>
From: "Dinesh Pandey" <dpandey@secf.com>
To: "'PostgreSQL'" <pgsql-sql@postgresql.org>
Subject: dynamic 'INSERT'  query?
Date: Thu, 14 Apr 2005 17:07:54 +0530
Organization: Second Foundation India P Ltd.
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0025_01C54114.815D64A0"
X-Mailer: Microsoft Office Outlook, Build 11.0.5510
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Thread-Index: AcVA5mVy32wnVP7MThavkPaeQwA55w==
X-Authenticated-Sender: dpandey@secf.com
X-Spam-Processed: mail.secf.com, Thu, 14 Apr 2005 04:40:32 -0700
	(not processed: message from valid local sender)
X-MDRemoteIP: 220.227.32.11
X-Return-Path: dpandey@secf.com
X-MDaemon-Deliver-To: pgsql-sql@postgresql.org
X-MDAV-Processed: mail.secf.com, Thu, 14 Apr 2005 04:40:32 -0700
Message-Id: <20050414114131.C840B53726@svr1.postgresql.org>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.502 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO, HTML_MESSAGE, MSGID_FROM_MTA_ID, UPPERCASE_25_50
X-Spam-Level: *
X-Archive-Number: 200504/187
X-Sequence-Number: 21080

This is a multi-part message in MIME format.


------=_NextPart_000_0025_01C54114.815D64A0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

How can we set A1, A2 values in dynamic 'INSERT'  query?

 

DECLARE

 _record        RECORD;

 _sql             VARCHAR(2000);

 

FOR _record IN SELECT A1, A2 FROM A

LOOP

 

_sql := 'INSERT INTO B VALUES (:A1, :A2)';

 

EXECUTE (_sql);

 

END LOOP;

 

=================================================================

I can do this as (but I need another way instead of using || operator).

 

_sql := 'INSERT INTO B VALUES (' || _record.A1 || ',' || _record.A2 || ')';

=================================================================

 

Regards
Dinesh Pandey


----------------------------------------------------------------------------
------
Dinesh Pandey 
Sr. Software Engineer



 


------=_NextPart_000_0025_01C54114.815D64A0
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
 name=3D"place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Verdana;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
p
	{mso-margin-top-alt:auto;
	margin-right:0in;
	mso-margin-bottom-alt:auto;
	margin-left:0in;
	font-size:10.0pt;
	font-family:Verdana;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:Verdana;
	color:windowtext;
	font-weight:normal;
	font-style:normal;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;
font-family:Verdana'>How can we set A1, A2 values in dynamic =
'INSERT&#8217; &nbsp;query?<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;
font-family:Verdana'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;
font-family:Verdana'>DECLARE<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;
font-family:Verdana'>&nbsp;_record &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
RECORD;<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;
font-family:Verdana'>&nbsp;_sql&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
VARCHAR(2000);<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;
font-family:Verdana'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;
font-family:Verdana'>FOR _record IN SELECT A1, A2 FROM =
A<o:p></o:p></span></font></p>

<p class=3DMsoNormal><st1:place w:st=3D"on"><font size=3D2 =
face=3DVerdana><span
 =
style=3D'font-size:10.0pt;font-family:Verdana'>LOOP</span></font></st1:pl=
ace><font
size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;font-family:Verdana'><o:p></o:p></span></font><=
/p>

<p class=3DMsoNormal><font size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;
font-family:Verdana'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-indent:.5in'><font size=3D2 =
face=3DVerdana><span
style=3D'font-size:10.0pt;font-family:Verdana'>_sql :=3D 'INSERT INTO B =
VALUES (<b><font
color=3Dred><span style=3D'color:red;font-weight:bold'>:A1, =
:A2</span></font></b>)&#8217;;<o:p></o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-indent:.5in'><font size=3D2 =
face=3DVerdana><span
style=3D'font-size:10.0pt;font-family:Verdana'><o:p>&nbsp;</o:p></span></=
font></p>

<p class=3DMsoNormal style=3D'text-indent:.5in'><font size=3D2 =
face=3DVerdana><span
style=3D'font-size:10.0pt;font-family:Verdana'>EXECUTE =
(_sql);<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;
font-family:Verdana'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;
font-family:Verdana'>END <st1:place =
w:st=3D"on">LOOP</st1:place>;<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;
font-family:Verdana'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;
font-family:Verdana'>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<o:p></=
o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;
font-family:Verdana'>I can do this as (but I need another way instead of =
using
|| operator).<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;
font-family:Verdana'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal style=3D'text-indent:.5in'><font size=3D2 =
face=3DVerdana><span
style=3D'font-size:10.0pt;font-family:Verdana'>_sql :=3D 'INSERT INTO B =
VALUES (&#8216;
|| _record.A1 || &#8217;,&#8217; || _record.A2 || =
&#8217;)&#8217;;<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;
font-family:Verdana'>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<o:p></=
o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt;
font-family:Verdana'><o:p>&nbsp;</o:p></span></font></p>

<p><font size=3D2 face=3DVerdana><span =
style=3D'font-size:10.0pt'>Regards<br>
Dinesh Pandey</span></font><font face=3D"Times New Roman"><span =
style=3D'font-family:
"Times New Roman"'><br>
<br>
<br>
<b><font color=3Dgray><span =
style=3D'color:gray;font-weight:bold'>-----------------------------------=
-----------------------------------------------</span></font></b></span><=
/font><br>
<b><font color=3Dgray><span style=3D'color:gray;font-weight:bold'>Dinesh =
Pandey</span></font></b>&nbsp;<br>
<font color=3Dgray><span style=3D'color:gray'>Sr. Software Engineer<br>
<br>
</span></font><o:p></o:p></p>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

</div>

</body>

</html>

------=_NextPart_000_0025_01C54114.815D64A0--




From sdavis2@mail.nih.gov Thu Apr  14 11:59:13 2005
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 2453B5366A
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 14 Apr 2005 08:59:13 -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 18971-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 14 Apr 2005 11:59:04 +0000 (GMT)
Received: from mx5.net.nih.gov (mailfwd.nih.gov [165.112.130.36])
	by svr1.postgresql.org (Postfix) with ESMTP id 35057536F6
	for <pgsql-sql@postgresql.org>; Thu, 14 Apr 2005 08:59:03 -0300 (ADT)
Received: from mx5.net.nih.gov (localhost [127.0.0.1])
	by mx5.net.nih.gov (8.12.10/8.11.6) with ESMTP id j3EBx5aq028133
	for <pgsql-sql@postgresql.org>; Thu, 14 Apr 2005 07:59:05 -0400
Received: from [128.231.145.14] (holmes.nhgri.nih.gov [128.231.145.14])
	by mx5.net.nih.gov (8.12.10/8.11.6) with ESMTP id j3EBx5Kd028130;
	Thu, 14 Apr 2005 07:59:05 -0400
In-Reply-To: <20050414114131.C840B53726@svr1.postgresql.org>
References: <20050414114131.C840B53726@svr1.postgresql.org>
Mime-Version: 1.0 (Apple Message framework v619.2)
Content-Type: text/plain; charset=WINDOWS-1252; format=flowed
Message-Id: <e9917654069296414165126cade4505c@mail.nih.gov>
Content-Transfer-Encoding: quoted-printable
Cc: "'PostgreSQL'" <pgsql-sql@postgresql.org>
From: Sean Davis <sdavis2@mail.nih.gov>
Subject: Re: dynamic 'INSERT'  query?
Date: Thu, 14 Apr 2005 07:59:05 -0400
To: <dpandey@secf.com>
X-Mailer: Apple Mail (2.619.2)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200504/189
X-Sequence-Number: 21082


On Apr 14, 2005, at 7:37 AM, Dinesh Pandey wrote:

> How can we set A1, A2 values in dynamic 'INSERT=92 =A0query?
>
> =A0
>
> DECLARE
>
> =A0_record =A0=A0=A0=A0=A0=A0 RECORD;
>
> =A0_sql=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 VARCHAR(2000);
>
> =A0
>
> FOR _record IN SELECT A1, A2 FROM A
>
> LOOP
>
> =A0
>
> _sql :=3D 'INSERT INTO B VALUES (:A1, :A2)=92;
>
> =A0
>
> EXECUTE (_sql);
>
> =A0
>
> END LOOP;
>
> =A0
>
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>
> I can do this as (but I need another way instead of using || =
operator).
>
> =A0
>
> _sql :=3D 'INSERT INTO B VALUES (=91 || _record.A1 || =92,=92 || =
_record.A2 ||=20
> =92)=92;
>

Dinesh,

I think what you are showing here IS the way to build up a dynamic sql=20=

statement.  I'm not sure that you can write a prepared statement within=20=

the body of a function, which would then look more like what you are=20
suggesting you want to do--perhaps others on the list can enlighten us=20=

about that.  In any case, why won't using the || operator work for you?

Sean




From dpandey@secf.com Thu Apr  14 12:06:43 2005
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 3B80A53689
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 14 Apr 2005 09:06:43 -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 22309-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 14 Apr 2005 12:06:36 +0000 (GMT)
Received: from secf.com (209-128-104-244.bayarea.net [209.128.104.244])
	by svr1.postgresql.org (Postfix) with ESMTP id D513853646
	for <pgsql-sql@postgresql.org>; Thu, 14 Apr 2005 09:06:34 -0300 (ADT)
Received: from dinesh by secf.com (MDaemon.PRO.v7.2.2.R)
	with ESMTP id md50000632922.msg
	for <pgsql-sql@postgresql.org>; Thu, 14 Apr 2005 05:05:54 -0700
Reply-To: <dpandey@secf.com>
From: "Dinesh Pandey" <dpandey@secf.com>
To: "'Juris Zeltins'" <juris.zeltins@gmail.com>
Cc: "'PostgreSQL'" <pgsql-sql@postgresql.org>
Subject: Re: dynamic 'INSERT'  query?
Date: Thu, 14 Apr 2005 17:33:13 +0530
Organization: Second Foundation India P Ltd.
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook, Build 11.0.5510
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Thread-Index: AcVA6Ee77Kn9jtcBRE+utxpzPwRjuAAAYp0g
In-Reply-To: <425E57DD.6060203@gmail.com>
X-Authenticated-Sender: dpandey@secf.com
X-Spam-Processed: mail.secf.com, Thu, 14 Apr 2005 05:05:54 -0700
	(not processed: message from valid local sender)
X-MDRemoteIP: 220.227.32.11
X-Return-Path: dpandey@secf.com
X-MDaemon-Deliver-To: pgsql-sql@postgresql.org
X-MDAV-Processed: mail.secf.com, Thu, 14 Apr 2005 05:05:55 -0700
Message-Id: <20050414120634.D513853646@svr1.postgresql.org>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.503 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO, MSGID_FROM_MTA_ID, UPPERCASE_25_50
X-Spam-Level: *
X-Archive-Number: 200504/190
X-Sequence-Number: 21083


FOR _record IN SELECT A1, A2 FROM A

LOOP

--[Dinesh Pandey] -- Sorry I didn't get this part.
_sql := "INSERT INTO B VALUES ( '*" || _record.A1 || "'** , '" || _record.A2
|| "' ***)";

EXECUTE (_sql);

END LOOP;



Dinesh Pandey wrote:

> How can we set A1, A2 values in dynamic 'INSERT' query?
>
> DECLARE
>
> _record RECORD;
>
> _sql VARCHAR(2000);
>
> FOR _record IN SELECT A1, A2 FROM A
>
> LOOP
>
> _sql := 'INSERT INTO B VALUES (*:A1, :A2*)';
>
> EXECUTE (_sql);
>
> END LOOP;
>
> =================================================================
>
> I can do this as (but I need another way instead of using || operator).
>
> _sql := 'INSERT INTO B VALUES (' || _record.A1 || ',' || _record.A2 || 
> ')';
>
> =================================================================
>
> Regards
> Dinesh Pandey
>
>
>
*---------------------------------------------------------------------------
-------*
> *Dinesh Pandey*
> Sr. Software Engineer
>






From tgl@sss.pgh.pa.us Thu Apr  14 14:53:17 2005
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id F385453D83
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 14 Apr 2005 11:53:17 -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 95778-01
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 14 Apr 2005 14:53:14 +0000 (GMT)
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 2D04653710
	for <pgsql-sql@postgresql.org>; Thu, 14 Apr 2005 11:53:10 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j3EErEYC000565;
	Thu, 14 Apr 2005 10:53:15 -0400 (EDT)
To: dpandey@secf.com
Cc: "'PostgreSQL'" <pgsql-sql@postgresql.org>
Subject: Re: dynamic 'INSERT' query? 
In-reply-to: <20050414114131.C840B53726@svr1.postgresql.org> 
References: <20050414114131.C840B53726@svr1.postgresql.org>
Comments: In-reply-to "Dinesh Pandey" <dpandey@secf.com>
	message dated "Thu, 14 Apr 2005 17:07:54 +0530"
Date: Thu, 14 Apr 2005 10:53:14 -0400
Message-ID: <564.1113490394@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200504/192
X-Sequence-Number: 21085

"Dinesh Pandey" <dpandey@secf.com> writes:
> FOR _record IN SELECT A1, A2 FROM A
> LOOP
> _sql := 'INSERT INTO B VALUES (:A1, :A2)';
> EXECUTE (_sql);

Why do you need a dynamic query here at all?  You could just do

  FOR _record IN SELECT A1, A2 FROM A
  LOOP
    INSERT INTO B VALUES (_record.A1, _record.A2);

This would be much faster as well as simpler to code.

As far as I can see offhand, you only need EXECUTE when you want to
change table and/or field names from one execution to the next of
a particular query.  If you have such a problem, you are omitting
the important details ...

			regards, tom lane



From dpandey@secf.com Thu Apr  14 15:01:07 2005
X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 1DA1953724
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 14 Apr 2005 12:01:07 -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 97763-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 14 Apr 2005 15:01:05 +0000 (GMT)
Received: from secf.com (209-128-104-244.bayarea.net [209.128.104.244])
	by svr1.postgresql.org (Postfix) with ESMTP id 457BB53F8C
	for <pgsql-sql@postgresql.org>; Thu, 14 Apr 2005 12:01:04 -0300 (ADT)
Received: from dinesh by secf.com (MDaemon.PRO.v7.2.2.R)
	with ESMTP id md50000633583.msg
	for <pgsql-sql@postgresql.org>; Thu, 14 Apr 2005 08:00:24 -0700
Reply-To: <dpandey@secf.com>
From: "Dinesh Pandey" <dpandey@secf.com>
To: "'Tom Lane'" <tgl@sss.pgh.pa.us>
Cc: "'PostgreSQL'" <pgsql-sql@postgresql.org>
Subject: Re: dynamic 'INSERT' query?
Date: Thu, 14 Apr 2005 20:27:46 +0530
Organization: Second Foundation India P Ltd.
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook, Build 11.0.5510
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Thread-Index: AcVBAbbxGsSPlARtRC2+jib20x9jzQAAAYjg
In-Reply-To: <564.1113490394@sss.pgh.pa.us>
X-Authenticated-Sender: dpandey@secf.com
X-Spam-Processed: mail.secf.com, Thu, 14 Apr 2005 08:00:24 -0700
	(not processed: message from valid local sender)
X-MDRemoteIP: 220.227.32.11
X-Return-Path: dpandey@secf.com
X-MDaemon-Deliver-To: pgsql-sql@postgresql.org
X-MDAV-Processed: mail.secf.com, Thu, 14 Apr 2005 08:00:27 -0700
Message-Id: <20050414150104.457BB53F8C@svr1.postgresql.org>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.508 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO, MSGID_FROM_MTA_ID, UPPERCASE_25_50
X-Spam-Level: *
X-Archive-Number: 200504/195
X-Sequence-Number: 21088

Yes here the TABLE NAME is also coming at runtime.

Like In Oracle I have done in this way:
-------------------------------------------
LOOP
	v_sql := 'INSERT INTO ' || mytable || ' VALUES(:in_sentryid_id,
:in_node_id)';	
	EXECUTE IMMEDIATE v_sql USING v_sentryid, v_nodeid;		
END LOOP;

How to convert this into Postgres?????

Thanks
Dinesh Pandey