summaryrefslogtreecommitdiff
path: root/src/sql/selectUninsertableLines.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/sql/selectUninsertableLines.sql')
-rw-r--r--src/sql/selectUninsertableLines.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/src/sql/selectUninsertableLines.sql b/src/sql/selectUninsertableLines.sql
index 060e800..2a57683 100644
--- a/src/sql/selectUninsertableLines.sql
+++ b/src/sql/selectUninsertableLines.sql
@@ -1,6 +1,7 @@
SELECT
id,
- value
+ value,
+ cast(detail ->> 'hostnameId' AS int) AS hostnameId
FROM
entities
WHERE