Mercurial > hg > orthanc-databases
diff PostgreSQL/Plugins/CreateInstance.sql @ 72:8dd29af7c844 db-changes
new extension: FastTotalSize
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Fri, 04 Jan 2019 14:43:35 +0100 |
parents | d40c5fecd160 |
children | e61587582cef |
line wrap: on
line diff
--- a/PostgreSQL/Plugins/CreateInstance.sql Fri Jan 04 13:51:52 2019 +0100 +++ b/PostgreSQL/Plugins/CreateInstance.sql Fri Jan 04 14:43:35 2019 +0100 @@ -10,7 +10,8 @@ OUT patientKey BIGINT, OUT studyKey BIGINT, OUT seriesKey BIGINT, - OUT instanceKey BIGINT) AS $$ + OUT instanceKey BIGINT) AS $body$ + BEGIN SELECT internalId FROM Resources INTO instanceKey WHERE publicId = instance AND resourceType = 3; @@ -63,4 +64,5 @@ isNewInstance := 1; END IF; END; -$$ LANGUAGE plpgsql; + +$body$ LANGUAGE plpgsql;