diff options
Diffstat (limited to '')
| -rw-r--r-- | crates/secd/store/sqlite/sql/find_address.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/crates/secd/store/sqlite/sql/find_address.sql b/crates/secd/store/sqlite/sql/find_address.sql new file mode 100644 index 0000000..da1df81 --- /dev/null +++ b/crates/secd/store/sqlite/sql/find_address.sql @@ -0,0 +1,8 @@ +select address_public_id + , type + , value + , created_at +from address +where (($1 is null) or (address_public_id = $1)) +and (($2 is null) or (type = $2)) +and (($3 is null) or (value = $3)); |