Seeking Senior DBA - Franklin, MA - Mailing list pgsql-admin

<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
VirtualAssistant 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
interactas 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
/>applicationsplatform and design distributed database infrastructure for <br />multi-tiered data storage, high
availabilityand 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@verizon.net<br />781.587.0585 <br /><br /></div></span><div> </div><div style="MARGIN: 5px 0px; BORDER-TOP:
#bcbcbc1px solid"></div><span style="FONT-FAMILY: arial; COLOR: #000000; FONT-SIZE: 12px">On 07/19/12,
<span>Madhu.Lanka<mlanka@avineonindia.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 class="MsoNormal"> <p
class="MsoNormal">Canu please help to write a function for the following scenario?<p class="MsoNormal"> <p
class="MsoNormal">Ihave 3 table’s user_roles, principals and roles.<p class="MsoNormal">I have to write a function in
postgresqlwhich should excepts 2 parameters (name, password)<p class="MsoNormal">With those 2 parameters the query
shouldbe executed and return the result.(Result of the query will be 1 or more rows).<p class="MsoNormal">The query is
workingfine if executed it manually by hardcoding the values for name and password, but is as to be written in function
sothat I can send different values.<p class="MsoNormal"> <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
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
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
class="MsoNormal">r.right_route_analysis,r.right_legend,r.right_treeview,r.insert,r.update,r.delete,r.query,r.lock from
user_rolesu,.principals p,roles r where p.PRINCIPAL_ID = u.USER_ID and <p class="MsoNormal">r.role_id = u.role_id and
<spanstyle="BACKGROUND: yellow; mso-highlight: yellow">p.name=?</span> and <span style="BACKGROUND: yellow;
mso-highlight:yellow">p.password=?</span>”;<p class="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal">Thanks in
Advance.<pclass="MsoNormal"> <p class="MsoNormal">Regards<p class="MsoNormal">Madhu.Lanka</div></div></div>