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_negate_operator.sql
Raw

priv/SQL/postgres/define_negate_operator.sql 

CREATE OR REPLACE FUNCTION money_negate(money_1 money_with_currency)

RETURNS money_with_currency

IMMUTABLE

STRICT

LANGUAGE plpgsql

AS $$

    DECLARE

    currency varchar;

    addition numeric;

    BEGIN

    currency := currency_code(money_1);

    addition := amount(money_1) * -1;

    return row(currency, addition);

    END;

$$;





CREATE OPERATOR - (

    rightarg = money_with_currency,

    procedure = money_neg

);