Questions

1. What are some concerns about using PL/pgSQL functions, as compared to SQL functions?
2. What's the difference between a function and procedure?
3. What's the difference between a security invoker and security definer ?
4. Write a function in pl/pgSQL to find the greatest common divisor, using iteration.
5. Write a function in pl/pgSQL to find the greatest common divisor, using recursion.
6. Write a function in SQL to find the greatest common divisor, using recursion.
7. How can polymorphism be achieved in pl/pgSQL?
8. What's the difference between return SETOF and return TABLE?
9. What's the meaning of dynamic SQL?
10. Why it is recommended to use the format function when writing functions and stored procedures?
11. Describe how functions can be used when defining triggers.