Lectures

In this lecture, you'll learn how to create simple functions in PostgreSQL using CREATE FUNCTION with the PL/pgSQL language. We'll go over the syntax, examples with parameters, return values and tables, plus common mistakes when writing functions.

In this lecture, you'll learn how to return values from functions in PL/pgSQL: from a simple RETURN of a single value to returning tables, multiple rows using RETURN QUERY, RETURNS TABLE, and SETOF. We'll break down common mistakes and practical examples for different scenarios.

Learn how to call user-defined functions right from your SQL queries in PostgreSQL: automate calculations, process data in SELECT, INSERT, UPDATE, filter with WHERE, integrate with aggregates, and avoid common mistakes. Real-life examples for your daily database work.

In this lecture, you'll learn how to use RAISE NOTICE for printing messages and debugging in PL/pgSQL, and also how to return data sets from functions using RETURN QUERY. Examples, common mistakes, and practical tips for working efficiently with PostgreSQL functions.

In this lecture, we're gonna check out the most common mistakes when creating functions in PL/pgSQL: from forgetting RETURNS and RETURN to name conflicts, data type issues, and SQL injections. You'll learn how to dodge these, how to properly debug your functions, and how to write safe code.