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
43
44
|
CREATE OR REPLACE FUNCTION myf ()
RETURNS json
LANGUAGE plpgsql
AS $$
DECLARE
BEGIN
foo := 0.5;
bar := 1;
baz := GREATEST (baz, 1.0);
CASE result.attribute_value
WHEN 'asdf' THEN
foo := 0.5; bar := 1; baz := GREATEST (baz, 1.0);
END CASE;
END;
$$;
SELECT
z.zoo_id,
z.log_date,
a.firstname,
a.lastname,
zb.break_start
FROM
zoo z
JOIN animals a ON z.animal_id = a.animal_id
AND z.zoo_id = 9
JOIN zoo_breaks zb ON z.zoo_id = zb.zoo_id
AND Date_trunc('minute', zb.break_start) - Date_trunc('minute', z.opening_time) < '2 hours'::interval
AND zb.automatic = TRUE
WHERE
z.log_date >= '2022-01-01'
ORDER BY
z.worker_id;
CREATE OR REPLACE VIEW test AS
SELECT
*
FROM
test1 AS a
INNER JOIN test2 AS b ON a.field1 = b.field1 AND b.field2 = 'data2' AND b.field3 = 'data3'
INNER JOIN test2 AS b ON a.field1 = b.field1 AND b.field2 = 'data2' AND b.field3 = 0
INNER JOIN test2 AS b ON a.field1 = b.field1 AND b.field2 = 'data2' AND b.field3 = 'data3'
INNER JOIN test2 AS b ON a.field1 = b.field1 AND b.field2 = 'data2' AND b.field3 = 'data3';
|
