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

Instruction

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.

Exercise

Run the template query.