質問編集履歴
3
注釈追加
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -20,7 +20,7 @@
|
|
|
20
20
|
status = ?
|
|
21
21
|
WHERE place_name IN (
|
|
22
22
|
SELECT
|
|
23
|
-
place_name::text
|
|
23
|
+
place_name::text --- sql-2と条件は異なりますが、最終的には'hogehoge'になります。
|
|
24
24
|
FROM
|
|
25
25
|
payment_tag_places
|
|
26
26
|
WHERE
|
2
例文切り出し
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -27,6 +27,7 @@
|
|
|
27
27
|
payment_id = ?
|
|
28
28
|
)
|
|
29
29
|
RETURNING id, status;
|
|
30
|
+
|
|
30
31
|
```
|
|
31
32
|
```
|
|
32
33
|
###### sql-2 ######
|
|
@@ -38,4 +39,5 @@
|
|
|
38
39
|
'hogehoge'::text
|
|
39
40
|
)
|
|
40
41
|
RETURNING id, status;
|
|
42
|
+
|
|
41
43
|
```
|
1
例文切り出し
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -27,7 +27,8 @@
|
|
|
27
27
|
payment_id = ?
|
|
28
28
|
)
|
|
29
29
|
RETURNING id, status;
|
|
30
|
-
|
|
30
|
+
```
|
|
31
|
+
```
|
|
31
32
|
###### sql-2 ######
|
|
32
33
|
UPDATE
|
|
33
34
|
places
|