From 07ce48145343202a074890a413459cad242a8cad Mon Sep 17 00:00:00 2001 From: schneefux Date: Wed, 8 Mar 2017 18:00:33 +0100 Subject: order by priority and id --- joblib.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/joblib.py b/joblib.py index 22f51d1..ba52382 100644 --- a/joblib.py +++ b/joblib.py @@ -80,7 +80,7 @@ class JobQueue(object): FROM ( SELECT id FROM jobs WHERE status='open' AND type=$1 - ORDER BY priority ASC + ORDER BY priority, id LIMIT $2 ) AS open_jobs WHERE jobs.id=open_jobs.id -- cgit v1.3.1