Pack size mart depends on custom array_product function

[jrlegrand]

Problem Statement

At one point, the int_fda_packaging_components model required me to multiple an aggregate array and the only way I could do this was with a custom PostgreSQL function. I don't think I ever documented this function (likely from Stackoverflow) and now it's not working. I temporarily replaced the total pack size with a NULL.

Criteria for Success

Add back a custom function and a way to ensure we instantiate our Postgres database with this function or otherwise solve this problem another way.

Additional Information

Ask ChatGPT?