By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
| person_id | email_address |
|---|---|
| 001 | billy@gmail.com |
| 002 | bobby@gmail.com |
| 003 | gregg@gmail.com |
| 004 | janet@gmail.com |
| 005 | boss1@gmail.com |
INSERT 0 5
CREATE TABLE
| msg_id | from_addr | to_addr | cc_addr | bcc_addr |
|---|---|---|---|---|
| 001 | billy@gmail.com | {gregg@gmail.com,dave@gmail.com} | {boss1@gmail.com} | null |
| 002 | bobby@gmail.com | {gregg@gmail.com} | null | null |
| 003 | janet@gmail.com | {boss1@gmail.com} | {bobby@gmail.com} | {gregg@gmail.com} |
INSERT 0 3
| msg_id | from_addr | to_addr | cc_addr | bcc_addr |
|---|---|---|---|---|
| 001 | billy@gmail.com | {gregg@gmail.com,dave@gmail.com} | {boss1@gmail.com} | null |
| 003 | janet@gmail.com | {boss1@gmail.com} | {bobby@gmail.com} | {gregg@gmail.com} |
SELECT 2