Re: How can I test a function in the SQL window?

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);

        ^