diff options
Diffstat (limited to 'sql/dawn.sql')
| -rw-r--r-- | sql/dawn.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/dawn.sql b/sql/dawn.sql index 0501a155..dbe531db 100644 --- a/sql/dawn.sql +++ b/sql/dawn.sql @@ -235,7 +235,7 @@ CREATE OR REPLACE VIEW orig_cds AS SELECT DISTINCT ON (dealid) dealid, folder, index, series, version, tenor, fixed_rate, notional, upfront, protection, attach, detach, trade_date, upfront_settle_date FROM cds JOIN index_desc ON index_desc.redindexcode=cds.security_id AND index_desc.maturity=cds.maturity -ORDER BY dealid, trade_date DESC; +ORDER BY dealid, trade_date; CREATE OR REPLACE function query_positions(p_type text DEFAULT NULL) RETURNS text AS $$ |