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

Reply via email to