X-Git-Url: http://git.shiar.net/sheet.git/blobdiff_plain/dd92616a516d41f9a84d080891f18d5a58754060..74d561810b2bf81617b84bc1581d8b59c359d5c9:/tools/word.pg.sql diff --git a/tools/word.pg.sql b/tools/word.pg.sql index 3a0f158..3c05c38 100644 --- a/tools/word.pg.sql +++ b/tools/word.pg.sql @@ -42,7 +42,8 @@ COMMENT ON COLUMN word.creator IS 'user responsible for initial submit'; CREATE OR REPLACE FUNCTION exportform(word) RETURNS text AS $$ SELECT concat( - $1.prio || CASE WHEN $1.cover THEN 'c' ELSE '' END || ':', + $1.id, ':', + $1.prio, CASE WHEN $1.cover THEN 'c' ELSE '' END, ':', array_to_string($1.form || $1.alt, '/') ); $$ LANGUAGE SQL IMMUTABLE;