Learn how to write your own functions in Postgres with this course

3/13 Invoke a function that returns a table #1

1. Functions returning tables – example

2. RETURNS TABLE with RETURN QUERY

3. Invoke a function that returns a table #1

4. Invoke a function that returns a table #2

5. Function returning a table – SETOF #1

6. Function returning a table – SETOF #2

7. RETURNS TABLE with RETURN NEXT

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.

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.

Instruction

Exercise

Need assistance?

login:
password:
Remember me on this computer

Recipient's Name:
Recipient's Email:
Your Message (Optional):

Select your platform

Sign upand join a company account!

Log in

Your registration has been successfully finished

Wrap course as a gift

Writing User-Defined Functions in PostgreSQL

Instruction

Exercise

Need assistance?