diff options
Diffstat (limited to 'crates/secd/store/pg/sql/find_identity.sql')
| -rw-r--r-- | crates/secd/store/pg/sql/find_identity.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/crates/secd/store/pg/sql/find_identity.sql b/crates/secd/store/pg/sql/find_identity.sql index 3a86a83..f4c9cbf 100644 --- a/crates/secd/store/pg/sql/find_identity.sql +++ b/crates/secd/store/pg/sql/find_identity.sql @@ -2,8 +2,8 @@ select identity_public_id, data, i.created_at -from auth.identity i -join auth.identity_email ie using (identity_id) -join auth.email e using (email_id) +from secd.identity i +join secd.identity_email ie using (identity_id) +join secd.email e using (email_id) where (($1 is null) or (i.identity_public_id = $1)) and (($2 is null) or (e.address = $2)) |