aboutsummaryrefslogtreecommitdiff
path: root/crates/secd/store/pg/sql/write_identity.sql
blob: e86d2f58908db06014e1ce5c712eb0c1e3d45528 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
insert into secd.identity (
       identity_public_id
       , data
       , created_at
       , updated_at
       , deleted_at
) values (
  $1, $2, $3, $4, $5
) on conflict (identity_public_id) do update
  set data = excluded.data
      , updated_at = excluded.updated_at
      , deleted_at = excluded.deleted_at
returning (xmax = 0);