Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Writing User-Defined Functions in PostgreSQL

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.