Postgres - Difference between SELECT function() and CALL function()?

Question

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.

Hi @TimBiegeleisen, usually I use SELECT statement, not CALL — Yuri Martiradonna
– Yuri Martiradonna, Commented May 13, 2019 at 10:19
there is a difference between sql functions that can be used for example in select clauses, these simply format or manipulate the selected column data. Stored procedures on the other hand cannot be selected only called as they are not functions but procedures (which have side-effects and so on..) — Nikos M.
– Nikos M., Commented May 13, 2019 at 10:20
see here dba.stackexchange.com/questions/194684/…, and dba.stackexchange.com/questions/2357/… — Nikos M.
– Nikos M., Commented May 13, 2019 at 10:23

Shubhangi · Accepted Answer · 2019-05-13 10:27:21Z

1

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

answered May 13, 2019 at 10:27

Shubhangi

2,2642 gold badges16 silver badges14 bronze badges

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

1 Comment

Oto Shavadze Over a year ago

Transaction can be crated inside procedure and not inside function - I don't get what do you mean, in function there is possible creating transaction.

Collectives™ on Stack Overflow

Postgres - Difference between SELECT function() and CALL function()?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related