From 9f1dfacb0f236da5f0413ac20e3376388df7d798 Mon Sep 17 00:00:00 2001 From: Dan Goodliffe Date: Sat, 17 Jan 2026 18:33:56 +0000 Subject: pg_format schema.sql and sql/*.sql No changes. --- src/sql/hostUpsert.sql | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) (limited to 'src/sql/hostUpsert.sql') diff --git a/src/sql/hostUpsert.sql b/src/sql/hostUpsert.sql index 2b1109c..18e8df8 100644 --- a/src/sql/hostUpsert.sql +++ b/src/sql/hostUpsert.sql @@ -1,7 +1,7 @@ -INSERT INTO entities (id, type, value, detail) - VALUES ($1, 'host', $2, jsonb_build_object('sysname', $3::text, 'release', - $4::text, 'version', $5::text, 'machine', $6::text, 'domainname', $7::text)) +INSERT INTO entities(id, type, value, detail) + VALUES ($1, 'host', $2, jsonb_build_object('sysname', $3::text, 'release', $4::text, + 'version', $5::text, 'machine', $6::text, 'domainname', $7::text)) ON CONFLICT ON CONSTRAINT pk_entities DO UPDATE SET - detail = jsonb_build_object('sysname', $3::text, 'release', - $4::text, 'version', $5::text, 'machine', $6::text, 'domainname', $7::text) + detail = jsonb_build_object('sysname', $3::text, 'release', $4::text, 'version', + $5::text, 'machine', $6::text, 'domainname', $7::text) -- cgit v1.2.3