stored procedures in postgresql user plpgsql - Mailing list pgsql-sql

<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I know that there are not stored procedures like that in oracle. I know that you have to create
functions.</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I have tried to create a simple function to select data from a table.  Could you all please correct
me</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Thanks</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">  CREATE FUNCTION retrive_atype(varchar) RETURNS varchar AS '</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">        BEGIN</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">            RETURN select username from masteraccount where atype=$1;</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">        END;</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">    ' LANGUAGE 'plpgsql';</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">To call the function I used </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">Select retrive_atype();</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Please help</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Comic Sans MS" size="3"><span style="font-size:
12.0pt;font-family:"Comic Sans MS"">Robert Stewart</span></font><p class="MsoNormal"><font face="Comic Sans MS"
size="3"><spanstyle="font-size: 
12.0pt;font-family:"Comic Sans MS"">Network Eng</span></font><p class="MsoNormal"><font face="Comic Sans MS"
size="3"><spanstyle="font-size: 
12.0pt;font-family:"Comic Sans MS"">Commonwealth Office of Technology</span></font><p class="MsoNormal"><font
face="ComicSans MS" size="3"><span style="font-size: 
12.0pt;font-family:"Comic Sans MS"">Finance and Administration Cabinet</span></font><p class="MsoNormal"><font
face="ComicSans MS" size="3"><span style="font-size: 
12.0pt;font-family:"Comic Sans MS"">101 Cold Harbor</span></font><p class="MsoNormal"><font face="Comic Sans MS"
size="3"><spanstyle="font-size: 
12.0pt;font-family:"Comic Sans MS"">Work # 502 564 9696</span></font><p class="MsoNormal"><font face="Comic Sans MS"
size="3"><spanstyle="font-size: 
12.0pt;font-family:"Comic Sans MS"">Cell # 502 330 5991</span></font><p class="MsoNormal"><font face="Comic Sans MS"
size="3"><spanstyle="font-size: 
12.0pt;font-family:"Comic Sans MS"">Email <a
href="mailto:RobertD.Stewart@ky.gov">RobertD.Stewart@ky.gov</a></span></font><pclass="MsoNormal"><font face="Times New
Roman"size="3"><span style="font-size: 
12.0pt"> </span></font></div>