How do I call a PostgreSQL Function that returns VOID from PGAdmin?

Question

I have a simple function defined in Postgresql defines as follows

CREATE OR REPLACE FUNCTION Foo(someid_param integer)
RETURNS void AS 
$$
BEGIN
    DELETE FROM SomeTable WHERE id = someid_param;
END;
$$ LANGUAGE plpgsql;

I've tried using EXEC, SELECT and PERFORM

PERFORM Foo(100);

But I get errors. What is the correct method for calling this function?

I'm using PGAdmin as my development environment.

"But I get errors." can you add the error you are getting? Would help — Jorge Campos
– Jorge Campos, Commented Apr 20, 2018 at 4:15
ERROR: syntax error at or near "PERFORM" LINE 1: PERFORM Foo(122) — JohnB
– JohnB, Commented Apr 20, 2018 at 4:22

clemens · Accepted Answer · 2018-04-20 04:37:41Z

3

PERFORM belongs to PL/pgSQL, and EXEC isn't valid SQL. So, you can't use them. You should use

SELECT foo(100);

This should return a single line with an empty column named foo.

answered Apr 20, 2018 at 4:37

clemens

17.9k12 gold badges52 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I call a PostgreSQL Function that returns VOID from PGAdmin?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related