Packages

ex_money_sql

1.10.2
2.0.0 1.12.0 1.11.1 1.11.0 1.10.2 1.10.1 1.10.0 1.9.3 1.9.2 1.9.1 1.9.0 1.8.0 1.7.3 1.7.2 1.7.1 1.6.0 1.5.2 1.5.1 1.5.0 1.4.5 1.4.4 1.4.3 1.4.2 1.4.1 retired 1.4.0 retired 1.3.1 1.3.0 1.2.1 1.2.0 1.1.0 1.0.0

Money functions for the serialization a money data type.

HexDocs

Current section

Files

Jump to
Readme
31 Versions
5 Dependencies
Dependants
Files
Activity
ex_money_sql priv SQL postgres define_minus_operator.sql
Raw

priv/SQL/postgres/define_minus_operator.sql 

CREATE OR REPLACE FUNCTION money_sub(money_1 money_with_currency, money_2 money_with_currency)

RETURNS money_with_currency

IMMUTABLE

STRICT

LANGUAGE plpgsql

AS $$

  DECLARE

    currency varchar;

    subtraction numeric;

  BEGIN

    IF currency_code(money_1) = currency_code(money_2) THEN

      currency := currency_code(money_1);

      subtraction := amount(money_1) - amount(money_2);

      return row(currency, subtraction);

    ELSE

      RAISE EXCEPTION

        'Incompatible currency codes for - operator. Expected both currency codes to be %', currency_code(money_1)

        USING HINT = 'Please ensure both columns have the same currency code',

        ERRCODE = '22033';

    END IF;

  END;

$$;





CREATE OPERATOR - (

    leftarg = money_with_currency,

    rightarg = money_with_currency,

    procedure = money_sub,

    commutator = -

);