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

12/13 Exercise 4

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

Brilliant! Now, let's complete the last recap exercise.

Invoke the function named get_users_of_three_best_answers() – write a SELECT statement that returns one column containing an array of users – each user in a (id, name, count_of_answers) format – returned by the function.

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?