[PostgreSQL] Conditional update
Ik heb dit soort dingen al geprobeerd:
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
2
3
4
5
6
7
8
9
10
11
12
UPDATE
vouchers.orders
IF voucher_docent=0
THEN
SET voucher_docent=1
ELSE
SET voucher_docent=0
ENDIF;
WHERE
student_id=3
AND
type_id=5
vouchers.orders
IF voucher_docent=0
THEN
SET voucher_docent=1
ELSE
SET voucher_docent=0
ENDIF;
WHERE
student_id=3
AND
type_id=5
Gesponsorde koppelingen:
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
UPDATE
vouchers.orders
SET
voucher_leverancier=(SELECT
CASE
WHEN voucher_leverancier=0
THEN 1
ELSE 0
END
FROM
vouchers.orders
WHERE
student_id=2
AND
type_id=4)
WHERE
student_id=2
AND
type_id=4;
vouchers.orders
SET
voucher_leverancier=(SELECT
CASE
WHEN voucher_leverancier=0
THEN 1
ELSE 0
END
FROM
vouchers.orders
WHERE
student_id=2
AND
type_id=4)
WHERE
student_id=2
AND
type_id=4;
