File: ex55.sql

package info (click to toggle)
pgformatter 5.9-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 7,964 kB
  • sloc: sql: 186,493; perl: 5,694; makefile: 2; sh: 1
file content (42 lines) | stat: -rw-r--r-- 525 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
 
CREATE FUNCTION job_next ()
    RETURNS SETOF job
    AS $$
DECLARE
    id uuid;
BEGIN
    SELECT
        id INTO id
    FROM
        job
    WHERE
        state = 'sched'
        AND scheduled >= now()
    ORDER BY
        scheduled,
        modified
    LIMIT 1
FOR UPDATE SKIP LOCKED;  -- ### 1 indent lost
END;
$$
LANGUAGE plpgsql;

SELECT
    *
FROM (
    SELECT
        *
    FROM
        mytable
    FOR UPDATE) AS ss
WHERE
    col1 = 5;

BEGIN;
SELECT
    *
FROM
    mytable
WHERE
    KEY = 1
FOR NO KEY UPDATE;
END;