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

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

4/13 Invoke a function that returns a table #2

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

13. Congratulations

Another way to call a function is like so:

SELECT *
FROM get_events('2017-01-01', '2017-12-31');

This statement returns the table that we defined in the function's body.

Show all active users (show user_id, user_name) and the number of posts each of them created.

Treat the function as a table. You'll have to join the result of the function get_active_users() with the post table.

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.