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.

1 Answers

0
Shubhangi On Best Solutions

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