Hello!
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 to run it
from PGAdmin's SQL window. But I can't call it. When I try
select standupdatestatus('12', 'Loaded', 100);
I get:
ERROR: query has no destination for result data
HINT: If you want to discard the results of a SELECT, use PERFORM instead.
CONTEXT: PL/pgSQL function standupdatestatus(text,text,integer) line 44 at SQL
statement
********** Error **********
ERROR: query has no destination for result data
SQL state: 42601
Hint: If you want to discard the results of a SELECT, use PERFORM instead.
Context: PL/pgSQL function standupdatestatus(text,text,integer) line 44 at SQL
statement
When I try
perform standupdatestatus('12', 'Loaded', 100);
I get:
ERROR: syntax error at or near "perform"
LINE 1: perform standupdatestatus('12', 'Loaded', 100);
^
********** Error **********
ERROR: syntax error at or near "perform"
SQL state: 42601
Character: 1
What do I need to do?
Thanks very much!
RobR