<div style="FONT-FAMILY: Georgia; COLOR: #000000; FONT-SIZE: 12px"><DIV>Interactions (<A class=parsedLink href="http://www.interactions.net/" target=_blank>www.interactions.net</A> ) is a <BR>mature start-up that provides Virtual Assistant applications (IVR/Speech <BR>Recognition) that significantly improve self-service for customer care. <BR>These applications break the mold of traditional automated self-service <BR>systems, allowing customers to interact as if they are speaking with a live <BR>agent.<BR><BR>We are seeking a<STRONG> Senior Database Administrator </STRONG>to join our team in <BR>Franklin, MA to develop database related features into our voice <BR>applications platform and design distributed database infrastructure for <BR>multi-tiered data storage, high availability and fault tolerance.<BR><BR>Might this be of interest?<BR></DIV><DIV> </DIV><DIV> </DIV><SPAN><DIV style="FONT-FAMILY: Georgia; COLOR: #000000; FONT-SIZE: 12px">Kelly Papa <BR>Corporate Recruiter <BR>kellypapa(at)verizon(dot)net <BR>781.587.0585 <BR><BR></DIV></SPAN><DIV> </DIV><DIV style="MARGIN: 5px 0px; BORDER-TOP: #bcbcbc 1px solid"></DIV><SPAN style="FONT-FAMILY: arial; COLOR: #000000; FONT-SIZE: 12px">On 07/19/12, <SPAN>Madhu.Lanka<mlanka(at)avineonindia(dot)com></SPAN> wrote:</SPAN><DIV> </DIV><DIV style="FONT-FAMILY: arial; COLOR: #000000; FONT-SIZE: 12px"><DIV class=WordSection1><P class=MsoNormal>Hi Friends</P><P class=MsoNormal> </P><P class=MsoNormal>Can u please help to write a function for the following scenario?</P><P class=MsoNormal> </P><P class=MsoNormal>I have 3 table’s user_roles, principals and roles.</P><P class=MsoNormal>I have to write a function in postgresql which should excepts 2 parameters (name, password)</P><P class=MsoNormal>With those 2 parameters the query should be executed and return the result.(Result of the query will be 1 or more rows).</P><P class=MsoNormal>The query is working fine if executed it manually by hardcoding the values for name and password, but is as to be written in function so that I can send different values.</P><P class=MsoNormal> </P><P class=MsoNormal>“select u.role_id,u.user_id,p.name,p.creation_date,p.telephone_number,p.email,p.remarks,p.city,p.state,p.country,p.postal_address,p.company_name,p.department_name,p.contact_person,</P><P class=MsoNormal>p.role_group,p.role_description,p.first_name,p.last_name,p.pincode,p.status,p.department_id,p.designation_id,r.role_name,r.right_edit,r.right_filter,r.right_search,r.right_browse,</P><P class=MsoNormal>r.right_print, r.right_download,r.right_admin_user,r.right_image_creator,r.right_vector_download,r.right_wps,r.right_queries_filter,r.right_google_map,r.right_user_management,</P><P class=MsoNormal>r.right_route_analysis, r.right_legend,r.right_treeview,r.insert,r.update,r.delete,r.query,r.lock from user_roles u,.principals p,roles r where p.PRINCIPAL_ID = u.USER_ID and </P><P class=MsoNormal>r.role_id = u.role_id and <SPAN style="BACKGROUND: yellow; mso-highlight: yellow">p.name=?</SPAN> and <SPAN style="BACKGROUND: yellow; mso-highlight: yellow">p.password=?</SPAN>”;</P><P class=MsoNormal> </P><P class=MsoNormal> </P><P class=MsoNormal>Thanks in Advance.</P><P class=MsoNormal> </P><P class=MsoNormal>Regards</P><P class=MsoNormal>Madhu.Lanka</P></DIV></DIV></div>