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

Returning tables and sets
Summary

Instruction

Now that we've successfully implemented this new function, we need to invoke it. There are two ways of calling that function. The first is to use SELECT, as usual:

SELECT get_events ('2017-01-01', '2017-12-31')

This statement returns one column that contains the array of events returned by the function.

Exercise

Invoke the new get_active_users() function using a SELECT statement so the result set contains one column, an array of active users – treat the function as a column.