Lines Matching refs:CONFLICT

22     ON CONFLICT(a) DO UPDATE SET b=excluded.b, c=c+1 WHERE t1.b<excluded.b;
30     ON CONFLICT(a) DO UPDATE SET b=excluded.b, c=c+1 WHERE t1.b<excluded.b;
40     ON CONFLICT(a) DO UPDATE SET b=excluded.b, c=c+1 WHERE t1.b<excluded.b;
48     ON CONFLICT(a) DO UPDATE SET b=excluded.b, c=t2.c+1 WHERE t2.b<excluded.b;
54     ON CONFLICT(a) DO UPDATE SET b=excluded.b, c=t1.c+1 WHERE t1.b<excluded.b;
62     ON CONFLICT(a) DO UPDATE SET b=excluded.b, c=c+1 WHERE t1.b<excluded.b;
66 # On an ON CONFLICT DO UPDATE, the before-insert, before-update, and
94     ON CONFLICT(a) DO UPDATE SET c=t1.c+1;
98 # On an ON CONFLICT DO NOTHING, only the before-insert trigger fires.
102   INSERT INTO t1(a,b) VALUES(1,2) ON CONFLICT DO NOTHING;
106 # With ON CONFLICT DO UPDATE and a failed WHERE, only the before-insert
112     ON CONFLICT(a) DO UPDATE SET c=c+1 WHERE c<0;
145     ON CONFLICT(a) DO UPDATE SET c=t1.c+1;
149 # On an ON CONFLICT DO NOTHING, only the before-insert trigger fires.
153   INSERT INTO t1(a,b) VALUES(1,2) ON CONFLICT DO NOTHING;
157 # With ON CONFLICT DO UPDATE and a failed WHERE, only the before-insert
163     ON CONFLICT(a) DO UPDATE SET c=c+1 WHERE c<0;