Spring Deals - hours only!Up to 70% off on all courses and bundles.-Close
Syntax of PL/pgSQL
Function parameters
19. OUT parameters – invoking the function #2
Handling exceptions


Awesome! Another way to invoke a function with OUT parameters is to treat it like a table (because OUT parameters essentialy generate columns):

SELECT * FROM get_count_of_employees(2);

The output is basically represetned as columns – one for each OUT parameter. Each of the columns has the name of the related OUT parameter. The first column is assigned the value 0; the second column is assigned the value 10.


Run the template query.