Re: Stored procedures and out parameters - Mailing list pgsql-hackers

From Vladimir Sitnikov
Subject Re: Stored procedures and out parameters
Date
Msg-id CAB=Je-GoVaHKoZQtuFLP4dxqh_H21h5qCtpN+gtqikwPiVmbYg@mail.gmail.com
Whole thread Raw
In response to Re: Stored procedures and out parameters  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
Peter>AFAICT in no case does it involve allowing functions to be called as procedures or vice versa.

Oracle DB uses the same way to execute both procedures and functions: pl/sql block.

For instance:
procedure) begin my_proc(); end;
function) begin :result := my_fun(); end;

Call like begin my_fun(); end; would fail.
However there's no dedicated command to call procedures or a command to call functions.

Vladimir

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Stored procedures and out parameters
Next
From: Andreas Joseph Krogh
Date:
Subject: Sv: Re: Query is over 2x slower with jit=on