Sign in
◑
Theme
apache
/
datafusion-sqlparser-rs
/
refs/heads/sqlite-in-table
/
.
/
fuzz
/
fuzz_seeds
/
postgres_on_conflict_target_predicate.sql
blob: a63d004f480d9f7fea1c566d6b57e1fac0edcd73 [
file
]
INSERT
INTO
t
(
a
,
b
)
VALUES
(
1
,
2
)
ON
CONFLICT
(
a
)
WHERE
b
>
0
DO NOTHING
;
INSERT
INTO
t
(
a
,
b
,
c
)
VALUES
(
2
,
2
,
3
)
ON
CONFLICT
(
a
,
c
)
WHERE
b
>
0
AND
c
IS
NOT
NULL
DO
UPDATE
SET
b
=
EXCLUDED
.
b
WHERE
t
.
b
<
10
;