moonshot questions

• regexp_replace with negative lookahead to clean up email addresses
• Aggregate numeric values from jsonb array of records (including NULL values)
• Change {NULL} in Postgres ARRAY to NULL
• Postgres regex begins with ^ and ends with $ using LIKE

moonshot answers