diff options
-rw-r--r-- | data/denorm.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/data/denorm.sql b/data/denorm.sql index 17c535a..915df09 100644 --- a/data/denorm.sql +++ b/data/denorm.sql @@ -56,7 +56,7 @@ CREATE VIEW denorm_transactions AS ( ) LEFT JOIN accounts transfer_accounts ON ( transactions_with_subtransactions.transfer_account_id = transfer_accounts.id ) LEFT JOIN tins ON ( - tins.tin = regexp_match(memo, '\mtin:([^ ]+)')[1] + tins.tin = (regexp_match(memo, '\mtin:([^ ]+)'))[1] ) ); @@ -112,7 +112,7 @@ CREATE VIEW denorm_scheduled_transactions AS ( ) LEFT JOIN accounts transfer_accounts ON ( scheduled_transactions_with_subtransactions.transfer_account_id = transfer_accounts.id ) LEFT JOIN tins ON ( - tins.tin = regexp_match(memo, '\mtin:([^ ]+)')[1] + tins.tin = (regexp_match(memo, '\mtin:([^ ]+)'))[1] ) ); |