summaryrefslogtreecommitdiff
path: root/src/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/schema.sql')
-rw-r--r--src/schema.sql8
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,