-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathdevice_type--0.0.1--0.0.2.sql
22 lines (20 loc) · 1.13 KB
/
device_type--0.0.1--0.0.2.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
DO $$
DECLARE version_num integer;
BEGIN
SELECT current_setting('server_version_num') INTO STRICT version_num;
IF version_num > 90600 THEN
EXECUTE $E$ ALTER FUNCTION device_type_in(cstring) PARALLEL SAFE $E$;
EXECUTE $E$ ALTER FUNCTION device_type_out(device_type) PARALLEL SAFE $E$;
EXECUTE $E$ ALTER FUNCTION device_type_recv(internal) PARALLEL SAFE $E$;
EXECUTE $E$ ALTER FUNCTION device_type_send(device_type) PARALLEL SAFE $E$;
EXECUTE $E$ ALTER FUNCTION device_type_eq(device_type, device_type) PARALLEL SAFE $E$;
EXECUTE $E$ ALTER FUNCTION device_type_ne(device_type, device_type) PARALLEL SAFE $E$;
EXECUTE $E$ ALTER FUNCTION device_type_lt(device_type, device_type) PARALLEL SAFE $E$;
EXECUTE $E$ ALTER FUNCTION device_type_le(device_type, device_type) PARALLEL SAFE $E$;
EXECUTE $E$ ALTER FUNCTION device_type_gt(device_type, device_type) PARALLEL SAFE $E$;
EXECUTE $E$ ALTER FUNCTION device_type_ge(device_type, device_type) PARALLEL SAFE $E$;
EXECUTE $E$ ALTER FUNCTION device_type_cmp(device_type, device_type) PARALLEL SAFE $E$;
EXECUTE $E$ ALTER FUNCTION hash_device_type(device_type) PARALLEL SAFE $E$;
END IF;
END;
$$;