Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
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.