crates/secd/store/pg/sql/write_email.sql


1
2
3
4
5
6
7
8
9
10
11

insert into secd.email (
       address
) values (
       $1
) on conflict (address) do nothing
returning email_id;
--
select email_id from secd.email where address = $1;
--
insert into secd.identity_email (identity_id, email_id, created_at) values ($1, $2, $3);
--