~ubuntu-branches/ubuntu/saucy/quassel/saucy-proposed

« back to all changes in this revision

Viewing changes to src/core/SQL/PostgreSQL/14/select_messagesAllNew.sql

  • Committer: Bazaar Package Importer
  • Author(s): Scott Kitterman
  • Date: 2010-02-17 12:49:50 UTC
  • mto: This revision was merged to the branch mainline in revision 59.
  • Revision ID: james.westby@ubuntu.com-20100217124950-v9hajw5d2xa6fszn
Tags: upstream-0.6~beta1
ImportĀ upstreamĀ versionĀ 0.6~beta1

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
 
SELECT messageid, bufferid, time,  type, flags, sender, message
2
 
FROM backlog
3
 
JOIN sender ON backlog.senderid = sender.senderid
4
 
WHERE backlog.bufferid IN (SELECT bufferid FROM buffer WHERE userid = :userid)
5
 
    AND backlog.messageid >= :firstmsg
6
 
ORDER BY messageid DESC