From f0e54f5c656399310da44b5d226931f7e150f19d Mon Sep 17 00:00:00 2001 From: Mischa POSLAWSKY Date: Thu, 14 Oct 2021 18:50:15 +0200 Subject: [PATCH] word: prefer reference image id in exportform rows --- tools/word.pg.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/tools/word.pg.sql b/tools/word.pg.sql index 4e5aca6..a142ebc 100644 --- a/tools/word.pg.sql +++ b/tools/word.pg.sql @@ -56,7 +56,7 @@ COMMENT ON COLUMN kind.truth IS 'link validity ranging from 0 (never) to 10 CREATE OR REPLACE FUNCTION exportform(word) RETURNS text AS $$ SELECT concat( - $1.id, ':', + coalesce($1.ref, $1.id), ':', $1.prio, CASE WHEN $1.cover THEN 'c' ELSE '' END, ':', array_to_string($1.form || $1.alt, '/') ); -- 2.30.0