How can I test a function in the SQL window?
От | Rob Richardson |
---|---|
Тема | How can I test a function in the SQL window? |
Дата | |
Msg-id | 67D108EDFAD3C148A593E6ED7DCB4BBD01153F2B3F@RADCONWIN2K8PDC.radcon.local обсуждение исходный текст |
Ответы |
Re: How can I test a function in the SQL window?
Re: How can I test a function in the SQL window? |
Список | pgadmin-support |
<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>
В списке pgadmin-support по дате отправления: