Prepared query ?

Поиск
Список
Период
Сортировка
От Dinesh Pandey
Тема Prepared query ?
Дата
Msg-id 20050414143144.1704853689@svr1.postgresql.org
обсуждение исходный текст
Ответы Re: Prepared query ?  (Frank Bax <fbax@sympatico.ca>)
Re: Prepared query ?  (Richard Huxton <dev@archonet.com>)
Список pgsql-sql
<div class="Section1"><p class="MsoNormal"><font face="Verdana" size="2"><span style="font-size:10.0pt;
font-family:Verdana">How can I </span></font><ol start="1" style="margin-top:0in" type="1"><li class="MsoNormal"
style="mso-list:l0level1 lfo1"><font face="Verdana" size="2"><span style="font-size:10.0pt;font-family:Verdana">Write a
preparedquery and </span></font><li class="MsoNormal" style="mso-list:l0 level1 lfo1"><font face="Verdana"
size="2"><spanstyle="font-size:10.0pt;font-family:Verdana">Set values at run time and </span></font><li
class="MsoNormal"style="mso-list:l0 level1 lfo1"><font face="Verdana" size="2"><span
style="font-size:10.0pt;font-family:Verdana">Executethat query for different values.</span></font></ol><p
class="MsoNormal"style="margin-left:.25in"><font face="Verdana" size="2"><span
style="font-size:10.0pt;font-family:Verdana"> </span></font><pclass="MsoNormal"><font face="Verdana" size="2"><span
style="font-size:10.0pt;font-family:Verdana">LOOP</span></font><fontface="Verdana" size="2"><span
style="font-size:10.0pt;font-family:Verdana"></span></font><pclass="MsoNormal" style="margin-left:.25in"><font
face="Verdana"size="2"><span style="font-size:10.0pt;font-family:Verdana">     …..</span></font><p class="MsoNormal"
style="margin-left:.25in"><fontface="Verdana" size="2"><span style="font-size:10.0pt;font-family:Verdana">    
…..</span></font><pclass="MsoNormal" style="margin-left:.25in;text-indent:.25in"><font face="Verdana" size="2"><span
style="font-size:10.0pt;font-family:Verdana">sql:= INSERT INTO MYTABLE VALUES(?, ?);</span></font><p class="MsoNormal"
style="margin-left:.25in;text-indent:.25in"><fontface="Verdana" size="2"><span
style="font-size:10.0pt;font-family:Verdana">……</span></font><pclass="MsoNormal"
style="margin-left:.25in;text-indent:.25in"><fontface="Verdana" size="2"><span
style="font-size:10.0pt;font-family:Verdana">--EXECUTE(sql);</span></font><p class="MsoNormal"><font face="Verdana"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Verdana">END LOOP;</span></font><p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size:10.0pt;
font-family:Verdana"> </span></font><p><font face="Verdana" size="2"><span style="font-size:10.0pt">Regards<br />
DineshPandey</span></font><font face="Times New Roman"><span style="font-family: 
"Times New Roman""><br /><br /><br /><b><font color="gray"><span
style="color:gray;font-weight:bold">----------------------------------------------------------------------------------</span></font></b></span></font><br
/><b><fontcolor="gray"><span style="color:gray;font-weight:bold">Dinesh Pandey</span></font></b> <br /><font
color="gray"><spanstyle="color:gray">Sr. Software Engineer<br /><br /> Second Foundation (India) Pvt. Ltd.<br /> Plot#
52<br/> Industrial Area, Phase II<br /> Chandigarh. (India)<br /> PH: (O) 0172-2639202, Extn: 233</span></font><p
class="MsoNormal"><fontface="Times New Roman" size="3"><span style="font-size: 
12.0pt"> </span></font></div>

В списке pgsql-sql по дате отправления:

Предыдущее
От: "Dinesh Pandey"
Дата:
Сообщение: Re: dynamic 'INSERT' query?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: dynamic 'INSERT' query?