diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2026-05-10 00:41:56 +0100 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2026-05-10 00:41:56 +0100 |
| commit | 5111c39ad9c1665347471da9fc1ae5737e37cde5 (patch) | |
| tree | 18af6b7aeecd7dd0e07b59f2bc48108cf0d172ca | |
| parent | 157614349f5f4c2387e0a970a4ca3ddaeaa23446 (diff) | |
| download | webstat-5111c39ad9c1665347471da9fc1ae5737e37cde5.tar.bz2 webstat-5111c39ad9c1665347471da9fc1ae5737e37cde5.tar.xz webstat-5111c39ad9c1665347471da9fc1ae5737e37cde5.zip | |
Be specific about values from entities table
Fixes compatibility with PostgreSQL 18 which fails due to ambiguity.
| -rw-r--r-- | src/schema.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/src/schema.sql b/src/schema.sql index 056f7ac..e09be28 100644 --- a/src/schema.sql +++ b/src/schema.sql @@ -78,12 +78,12 @@ BEGIN IF recid IS NULL THEN RETURN query SELECT - id, - detail IS NULL + e.id, + e.detail IS NULL FROM - entities + entities e WHERE - md5(value) = md5(newValue); + md5(e.value) = md5(newValue); END IF; RETURN query VALUES (recid, |