diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/dawn.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index f867bc71..9b53968d 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -2877,7 +2877,7 @@ CREATE TABLE beta_crt( PRIMARY KEY (date, strategy) ); -CREATE OR REPLACE VIEW public.payment_settlements +CREATE OR REPLACE VIEW payment_settlements AS SELECT trades.settle_date, trades.fund, cps.name, @@ -2927,7 +2927,7 @@ AS SELECT trades.settle_date, spots.settle_date, spots.fund, spots.cp_code, - 'spot'::text AS asset_class, + 'SPOT' AS asset_class, spots.cash_account AS account, unnest(ARRAY[spots.buy_currency, spots.sell_currency]) AS currency, unnest(ARRAY[spots.buy_amount, - spots.sell_amount]) AS amount @@ -2937,7 +2937,7 @@ AS SELECT trades.settle_date, unnest(ARRAY[fx_swaps.near_settle_date, fx_swaps.near_settle_date, fx_swaps.far_settle_date, fx_swaps.far_settle_date]) AS settle_date, fx_swaps.fund, fx_swaps.cp_code, - 'spot'::text AS asset_class, + 'SPOT' AS asset_class, fx_swaps.cash_account AS account, unnest(ARRAY[fx_swaps.near_buy_currency, fx_swaps.near_sell_currency, fx_swaps.far_buy_currency, fx_swaps.far_sell_currency]) AS currency, unnest(ARRAY[fx_swaps.near_buy_amount, - fx_swaps.near_sell_amount, fx_swaps.far_buy_amount, - fx_swaps.far_sell_amount]) AS amount |