Mercurial > lada > lada-server
changeset 1179:612107caf961
Declared variable in db function set_ort_id.
| author | Raimund Renkert <raimund.renkert@intevation.de> |
|---|---|
| date | Wed, 16 Nov 2016 17:02:22 +0100 |
| parents | 047a27138af6 |
| children | 87b55cdb1cad |
| files | db_schema/stammdaten_schema.sql |
| diffstat | 1 files changed, 1 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/db_schema/stammdaten_schema.sql Wed Nov 16 15:59:24 2016 +0100 +++ b/db_schema/stammdaten_schema.sql Wed Nov 16 17:02:22 2016 +0100 @@ -17,6 +17,7 @@ CREATE FUNCTION set_ort_id() RETURNS trigger LANGUAGE plpgsql AS $$ + DECLARE value text; BEGIN value = '#'::text || lpad((NEW.id::character varying)::text, 9, '0'::text); IF NEW.ort_id IS NULL THEN