Mercurial > hg > orthanc-databases

diff PostgreSQL/Plugins/CreateInstance.sql @ 72:8dd29af7c844 db-changes

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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;