In PostgreSQL v11,
Difference between SELECT function() and CALL procedure?
If I select a procedure this errore is returned:
ERROR: public.delete() is a procedure
To call a procedure, use CALL.
The procedure can not be SELECTed. Note following basic difference between procedure and function.
- In PostgreSQL 11, PROCEDURE was added
- Functions return value but procedures does not return values
- Transaction can be crated inside procedure and not inside function