<div class="WordSection1"><p class="MsoNormal">Hello!<p class="MsoNormal"> <p class="MsoNormal">I suddenly find myself
stumped. A co-worker gave me a function to use in my database, but it doesn’t seem to be doing anything. So, I wanted
torun it from PGAdmin’s SQL window. But I can’t call it. When I try<p class="MsoNormal"> <p class="MsoNormal">select
standupdatestatus('12','Loaded', 100);<p class="MsoNormal"> <p class="MsoNormal">I get:<p class="MsoNormal"> <p
class="MsoNormal">ERROR: query has no destination for result data<p class="MsoNormal">HINT: If you want to discard the
resultsof a SELECT, use PERFORM instead.<p class="MsoNormal">CONTEXT: PL/pgSQL function
standupdatestatus(text,text,integer)line 44 at SQL statement<p class="MsoNormal">********** Error **********<p
class="MsoNormal"> <pclass="MsoNormal">ERROR: query has no destination for result data<p class="MsoNormal">SQL state:
42601<pclass="MsoNormal">Hint: If you want to discard the results of a SELECT, use PERFORM instead.<p
class="MsoNormal">Context:PL/pgSQL function standupdatestatus(text,text,integer) line 44 at SQL statement<p
class="MsoNormal"> <pclass="MsoNormal">When I try<p class="MsoNormal"> <p class="MsoNormal">perform
standupdatestatus('12','Loaded', 100);<p class="MsoNormal"> <p class="MsoNormal">I get:<p class="MsoNormal"> <p
class="MsoNormal">ERROR: syntax error at or near "perform"<p class="MsoNormal">LINE 1: perform standupdatestatus('12',
'Loaded',100);<p class="MsoNormal"> ^<p class="MsoNormal">********** Error **********<p class="MsoNormal"> <p
class="MsoNormal">ERROR:syntax error at or near "perform"<p class="MsoNormal">SQL state: 42601<p
class="MsoNormal">Character:1<p class="MsoNormal"> <p class="MsoNormal">What do I need to do?<p class="MsoNormal"> <p
class="MsoNormal">Thanksvery much!<p class="MsoNormal"> <p class="MsoNormal">RobR</div>