Summary - Function

Compute tax with CREATE FUNCTION.

A function is SQL code that returns a value. Created with CREATE FUNCTION, called in SELECT.

CREATE FUNCTION get_tax(price DECIMAL)
RETURNS DECIMAL
AS $$
  SELECT price * 0.18;
$$;

Summary function.

The function get_tax is created. The expression price * 0.18 is evaluated and returned.

Exercise Summary - Function

Summary: create the get_tax function.

Show example solution

CREATE FUNCTION get_tax(price DECIMAL)
RETURNS DECIMAL
AS $$
  SELECT price * 0.18;
$$;