Re: Stored Procedure Problem - Mailing list pgsql-sql
| From | Atul |
|---|---|
| Subject | Re: Stored Procedure Problem |
| Date | |
| Msg-id | LHEOILFLDANINFJAGPEOIEFNCAAA.atul@imcindia.net Whole thread Raw |
| In response to | Stored Procedure Problem ("Atul" <atul@imcindia.net>) |
| Responses |
Re: Stored Procedure Problem
(Tomasz Myrta <jasiek@klaster.net>)
Re: Stored Procedure Problem (Roberto Mello <rmello@cc.usu.edu>) |
| List | pgsql-sql |
<div class="Section1"><p class="MsoNormal" style="mso-layout-grid-align:none;text-autospace:none"><font color="black" face="CourierNew" size="2"><span style="font-size:10.0pt;font-family: "Courier New";color:black">Hi,</span></font><font color="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"CourierNew"; color:black;mso-color-alt:windowtext"></span></font><p class="MsoNormal" style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family: "Courier New";color:black"><span style="mso-tab-count:1"> </span>How to return multiple columns through stored procedure.</span></font><fontcolor="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"CourierNew"; color:black;mso-color-alt:windowtext"></span></font><p class="MsoNormal" style="mso-layout-grid-align:none;text-autospace:none"><fontcolor="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family: "Courier New";color:black"> </span></font><font color="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family: "Courier New";color:black;mso-color-alt:windowtext"></span></font><p class="MsoNormal" style="text-indent:.5in;mso-layout-grid-align:none; text-autospace:none"><b><font color="blue" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"CourierNew";color:blue;font-weight:bold">Consider EX.</span></font></b><p class="MsoNormal"style="mso-layout-grid-align:none;text-autospace:none"><font color="black" face="Courier New" size="2"><spanstyle="font-size:10.0pt;font-family: "Courier New";color:black"> </span></font><font color="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family: "Courier New";color:black;mso-color-alt:windowtext"></span></font><p class="MsoNormal" style="margin-left:.5in;mso-layout-grid-align:none; text-autospace:none"><font color="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New";color:black">CREATEFUNCTION b_function() RETURNS varchar AS '</span></font><font color="black" face="Courier New" size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"; color:black;mso-color-alt:windowtext"></span></font><p class="MsoNormal" style="margin-left:.5in;mso-layout-grid-align:none; text-autospace:none"><font color="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New";color:black"><spanstyle="mso-spacerun: yes"> </span>DECLARE</span></font><font color="black" face="Courier New" size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"; color:black;mso-color-alt:windowtext"></span></font><p class="MsoNormal" style="margin-left:.5in;mso-layout-grid-align:none; text-autospace:none"><font color="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New";color:black"><spanstyle="mso-spacerun: yes"> </span>an_integer int4;</span></font><font color="black" face="CourierNew" size="2"><span style="font-size:10.0pt;font-family: "Courier New";color:black;mso-color-alt:windowtext"></span></font><p class="MsoNormal" style="margin-left:.5in;mso-layout-grid-align:none; text-autospace:none"><font color="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New";color:black"><spanstyle="mso-spacerun: yes"> </span>an_name<span style="mso-spacerun: yes"> </span>varchar;</span></font><fontcolor="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family: "Courier New";color:black;mso-color-alt:windowtext"></span></font><p class="MsoNormal" style="margin-left:.5in;mso-layout-grid-align:none; text-autospace:none"><font color="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New";color:black"><spanstyle="mso-spacerun: yes"> </span>BEGIN</span></font><font color="black" face="Courier New" size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"; color:black;mso-color-alt:windowtext"></span></font><p class="MsoNormal" style="margin-left:.5in;mso-layout-grid-align:none; text-autospace:none"><font color="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New";color:black"><spanstyle="mso-spacerun: yes"> </span>select into an_integer emp_id,an_name emp_name from employee;</span></font><fontcolor="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"CourierNew"; color:black;mso-color-alt:windowtext"></span></font><p class="MsoNormal" style="margin-left:.5in;mso-layout-grid-align:none; text-autospace:none"><font color="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New";color:black"><spanstyle="mso-spacerun: yes"> </span>return an_integer,an_name;</span></font><font color="black" face="CourierNew" size="2"><span style="font-size:10.0pt;font-family: "Courier New";color:black;mso-color-alt:windowtext"></span></font><p class="MsoNormal" style="margin-left:.5in;mso-layout-grid-align:none; text-autospace:none"><font color="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New";color:black"><spanstyle="mso-spacerun: yes"> </span>END;</span></font><font color="black" face="Courier New" size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"; color:black;mso-color-alt:windowtext"></span></font><p class="MsoNormal" style="margin-left:.5in;mso-layout-grid-align:none; text-autospace:none"><font color="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New";color:black"><spanstyle="mso-spacerun: yes"> </span>'</span></font><font color="black" face="Courier New" size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"; color:black;mso-color-alt:windowtext"></span></font><p class="MsoNormal" style="margin-left:.5in;mso-layout-grid-align:none; text-autospace:none"><font color="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New";color:black"><spanstyle="mso-spacerun: yes"> </span>LANGUAGE 'plpgsql';</span></font><font color="black" face="CourierNew" size="2"><span style="font-size:10.0pt;font-family: "Courier New";color:black;mso-color-alt:windowtext"></span></font><p class="MsoNormal"><span class="EmailStyle15"><font color="black"face="Arial" size="2"><span style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial"> </span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial" size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial">But This Gives Error(For Multiple column , not for single column)</span></font></span><p class="MsoNormal"><span class="EmailStyle15"><fontcolor="black" face="Arial" size="2"><span style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial">Please Let me know.</span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial"size="2"><span style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial"> </span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial" size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial">Thanks</span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial" size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial"> </span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial" size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial">Atul…</span></font></span></div>