X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2F14%2Fselect_messages.sql;h=1bd2683f9e169d6a212dc3e499f63e1dd9e38a21;hp=eae93cf6f2ded3c012fb63eb12c5b261f9d1a7bc;hb=4bb04fc5758f566e58d560d6f8c510c5cb038486;hpb=ebe8328821ff05692eb8f420cd0e54083d8b0927 diff --git a/src/core/SQL/PostgreSQL/14/select_messages.sql b/src/core/SQL/PostgreSQL/14/select_messages.sql index eae93cf6..1bd2683f 100644 --- a/src/core/SQL/PostgreSQL/14/select_messages.sql +++ b/src/core/SQL/PostgreSQL/14/select_messages.sql @@ -1,6 +1,6 @@ SELECT messageid, time, type, flags, sender, message FROM backlog -JOIN sender ON backlog.senderid = sender.senderid +LEFT JOIN sender ON backlog.senderid = sender.senderid WHERE bufferid = $1 ORDER BY messageid DESC LIMIT $2 \ No newline at end of file