diff options
| -rw-r--r-- | sql/et_tables.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/et_tables.sql b/sql/et_tables.sql index 5e9499d2..2eec3eec 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -665,7 +665,7 @@ CREATE OR REPLACE FUNCTION dealname_from_cusip(p_cusips VARIADIC varchar(10)[]) BEGIN RETURN QUERY SELECT dealname FROM dealcusipmapping a RIGHT JOIN (SELECT unnest($1) AS cusip, generate_subscripts(p_cusips, 1) AS id) b - ON b.cusip = a.cusip ORDER BY b.id; + USING (cusip) ORDER BY b.id; END; $$ LANGUAGE plpgsql; |