core: Fix PostgreSQL realname/avatarurl handling

[quassel.git] / src / core / SQL / PostgreSQL / select_senderid.sql

diff --git a/src/core/SQL/PostgreSQL/select_senderid.sql b/src/core/SQL/PostgreSQL/select_senderid.sql
index 63b124c..8ade1d3 100644 (file)
--- a/src/core/SQL/PostgreSQL/select_senderid.sql
+++ b/src/core/SQL/PostgreSQL/select_senderid.sql
@@ -1,3 +1,3 @@
 SELECT senderid
 FROM sender
-WHERE sender = $1 AND realname = $2 AND avatarurl = $3
+WHERE sender = $1 AND coalesce(realname, '') = coalesce($2, '') AND coalesce(avatarurl, '') = coalesce($3, '')