diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2026-01-17 18:33:56 +0000 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2026-01-17 20:33:37 +0000 |
| commit | 9f1dfacb0f236da5f0413ac20e3376388df7d798 (patch) | |
| tree | 9b4c52f35b8ee0215d4911a786efed382d803942 /src/sql/hostUpsert.sql | |
| parent | 30a9d45f5322a63c2adf1de7a248ba3a9a0c3903 (diff) | |
| download | webstat-9f1dfacb0f236da5f0413ac20e3376388df7d798.tar.bz2 webstat-9f1dfacb0f236da5f0413ac20e3376388df7d798.tar.xz webstat-9f1dfacb0f236da5f0413ac20e3376388df7d798.zip | |
pg_format schema.sql and sql/*.sql
No changes.
Diffstat (limited to 'src/sql/hostUpsert.sql')
| -rw-r--r-- | src/sql/hostUpsert.sql | 10 |
1 files changed, 5 insertions, 5 deletions
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) |