LENGTH(source) AS size
FROM jobs
ORDER BY id DESC);
-
--- CREATE OR REPLACE FUCNTION source_private(jobid INT) RETURNS BOOLEAN AS $$
--- BEGIN
--- private BOOLEAN;
--- problem TEXT;
--- contest TEXT;
-
--- SELECT private, problem, contest INTO STRICT private, problem, contest FROM jobs WHERE id = jobid;
--- IF private THEN
--- RETURN TRUE;
--- END IF
-
--- IF
--- END;
--- $$