質問編集履歴
4
バージョン追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -43,4 +43,9 @@
|
|
|
43
43
|
|
|
44
44
|
```
|
|
45
45
|
|
|
46
|
-
idに別名をつけてみたり色々しましたが正しく取得できません
|
|
46
|
+
idに別名をつけてみたり色々しましたが正しく取得できません
|
|
47
|
+
|
|
48
|
+
|
|
49
|
+
postgres (PostgreSQL) 13.4
|
|
50
|
+
|
|
51
|
+
です
|
3
項目変こぷ
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -18,6 +18,7 @@
|
|
|
18
18
|
hage = EXCLUDED.hage,
|
|
19
19
|
RETURNING
|
|
20
20
|
id,
|
|
21
|
+
hage,
|
|
21
22
|
COALESCE((SELECT hoage FROM test WHERE id = id), '') AS before_hoge
|
|
22
23
|
|
|
23
24
|
```
|
|
@@ -37,6 +38,7 @@
|
|
|
37
38
|
hage = EXCLUDED.hage,
|
|
38
39
|
RETURNING
|
|
39
40
|
id,
|
|
41
|
+
hage,
|
|
40
42
|
COALESCE((SELECT hoage FROM test WHERE id = 111), '') AS before_hoge
|
|
41
43
|
|
|
42
44
|
```
|
2
間違い実名ds
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -31,7 +31,7 @@
|
|
|
31
31
|
```
|
|
32
32
|
INSERT INTO
|
|
33
33
|
test {$column} VALUES {$holder}
|
|
34
|
-
ON CONFLICT ON CONSTRAINT
|
|
34
|
+
ON CONFLICT ON CONSTRAINT testsss DO UPDATE SET
|
|
35
35
|
code = EXCLUDED.code,
|
|
36
36
|
hoge = EXCLUDED.hoge,
|
|
37
37
|
hage = EXCLUDED.hage,
|
1
aa matigai
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -12,7 +12,7 @@
|
|
|
12
12
|
```
|
|
13
13
|
INSERT INTO
|
|
14
14
|
test VALUES ('001','hoge1', 'hage1'),('002','hoge2', 'hage2'),('003','hoge3', 'hage3')
|
|
15
|
-
ON CONFLICT ON CONSTRAINT
|
|
15
|
+
ON CONFLICT ON CONSTRAINT testsss DO UPDATE SET
|
|
16
16
|
code = EXCLUDED.code,
|
|
17
17
|
hoge = EXCLUDED.hoge,
|
|
18
18
|
hage = EXCLUDED.hage,
|