Код IT
← Каталог

Практикум PostgreSQL — PL/pgSQL — функции и процедуры

Фрагмент из «Практикум PostgreSQL»: PL/pgSQL — функции и процедуры.

sql infra-securityencyclopedia8-11-praktikum-postgresql-5 embed URL статья в энциклопедии
SQL main.sql 
CREATE OR REPLACE FUNCTION orders_total(p_customer_id bigint)
RETURNS numeric
LANGUAGE plpgsql
STABLE
AS $$
DECLARE
  v_total numeric;
BEGIN
  SELECT COALESCE(SUM(amount), 0) INTO v_total
  FROM orders
  WHERE customer_id = p_customer_id
    AND status = 'paid';

  RETURN v_total;
END;
$$;
CREATE OR REPLACE FUNCTION orders_total(p_customer_id bigint)
RETURNS numeric
LANGUAGE plpgsql
STABLE
AS $$
DECLARE
  v_total numeric;
BEGIN
  SELECT COALESCE(SUM(amount), 0) INTO v_total
  FROM orders
  WHERE customer_id = p_customer_id
    AND status = 'paid';

  RETURN v_total;
END;
$$;