Mercurial > lada > lada-server
diff db_schema/stammdaten_schema.sql @ 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 | 33dc7dc6b7bc |
| children | 1bc8ab13e1f7 |
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