aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_calc_itemizers
Parameters
Name
Type
Mode
total_amount
t_money
IN
itemizer_codes
text[]
IN
item_amount
t_money
OUT
itemizers
t_itemizer[]
OUT
Definition
-- SELECT ARRAY( -- select (code, rate, amount)::t_itemizer from sp_calc_itemizers(total_amount, itemizer_codes) -- ) WITH items AS ( select amount, (code, rate, amount)::t_itemizer AS itemizer from sp_calc_itemizers(total_amount, itemizer_codes) ) SELECT (total_amount-sum(amount))::t_money, array_agg(itemizer) FROM items