thequbit · September 5, 2015 00:24
diff --git a/postgresql update query b/postgresql update query
 UPDATE
 	  jobs j
 SET
 	  in_process = TRUE,
 	  start_run_datetime = now()
 FROM (
 	  SELECT
 		    jobs.id
 	  FROM
 		    jobs
 	  WHERE
 		    jobs.in_process = FALSE
 	  ORDER BY
 		    jobs.last_run_datetime
 	  LIMIT
 		    1
 	  ) sub
 WHERE
    j.id = sub.id
 RETURNING
 	  j;
	UPDATE
	jobs j
	SET
	in_process = TRUE,
	start_run_datetime = now()
	FROM (
	SELECT
	jobs.id
	FROM
	jobs
	WHERE
	jobs.in_process = FALSE
	ORDER BY
	jobs.last_run_datetime
	LIMIT
	1
	) sub
	WHERE
	j.id = sub.id
	RETURNING
	j;