From ArctosDB/arctos#9466
There are currently no commas in loan numbers transaction identifiers. Can we set up rules to keep it that way, so that we can safely use commas as list delimiters?
select guid_prefix, loan_number from collection inner join trans on collection.collection_id=trans.transaction_id
inner join loan on trans.transaction_id=loan.transaction_id where loan_number ilike '%,%';
select guid_prefix, accn_number from collection inner join trans on collection.collection_id=trans.transaction_id
inner join accn on trans.transaction_id=accn.transaction_id where accn_number ilike '%,%';
select guid_prefix, borrow_number from collection inner join trans on collection.collection_id=trans.transaction_id
inner join borrow on trans.transaction_id=borrow.transaction_id where borrow_number ilike '%,%';
From ArctosDB/arctos#9466
There are currently no commas in
loan numberstransaction identifiers. Can we set up rules to keep it that way, so that we can safely use commas as list delimiters?