What is a procedure?

Learn the server-side stored routine.

A stored procedure is SQL code stored in the database. Called by name.

CREATE PROCEDURE get_active()
LANGUAGE SQL
AS $$
  SELECT * FROM customers WHERE status = 'active';
$$;

This query returns active customers.

The procedure get_active is created. All columns are selected from customers. WHERE keeps only the rows where status = 'active' holds.

What is a procedure? — details

A procedure is called repeatedly. It does complex operations in one step.

For example, you bundle creating an order, decreasing stock and writing a log into one procedure; the application just triggers it with CALL.

Create a procedure named get_active.

Show example solution

CREATE PROCEDURE get_active()
LANGUAGE SQL
AS $$
  SELECT * FROM customers WHERE status = 'active';
$$;

Add PROCEDURE

CREATE ____ get_active() AS $$
  SELECT * FROM customers WHERE status = 'active';
$$;

Show answer

CREATE PROCEDURE get_active() AS $$
  SELECT * FROM customers WHERE status = 'active';
$$;