svn commit: r1489570 - /cayenne/main/trunk/framework/cayenne-jdk1.5-unpublished/src/test/resources/ddl/postgresql/create-out-sp.sql

[aa...@apache.org]

Author: aadamchik
Date: Tue Jun  4 19:17:06 2013
New Revision: 1489570

URL: http://svn.apache.org/r1489570
Log:
actually postgresql does support out parameters

Modified:
    cayenne/main/trunk/framework/cayenne-jdk1.5-unpublished/src/test/resources/ddl/postgresql/create-out-sp.sql

Modified: cayenne/main/trunk/framework/cayenne-jdk1.5-unpublished/src/test/resources/ddl/postgresql/create-out-sp.sql
URL: http://svn.apache.org/viewvc/cayenne/main/trunk/framework/cayenne-jdk1.5-unpublished/src/test/resources/ddl/postgresql/create-out-sp.sql?rev=1489570&r1=1489569&r2=1489570&view=diff
==============================================================================
--- cayenne/main/trunk/framework/cayenne-jdk1.5-unpublished/src/test/resources/ddl/postgresql/create-out-sp.sql (original)
+++ cayenne/main/trunk/framework/cayenne-jdk1.5-unpublished/src/test/resources/ddl/postgresql/create-out-sp.sql Tue Jun  4 19:17:06 2013
@@ -1,7 +1,6 @@
-/* Postgres has no OUT parameters .. this procedure had to be changed to return the value. */
-CREATE OR REPLACE function cayenne_tst_out_proc (int4) RETURNS int4
+CREATE OR REPLACE function cayenne_tst_out_proc (IN int4, OUT int4) RETURNS int4
 AS '
 BEGIN
-	return $1 * 2;
+	$2 := $1 * 2;
 END;
 ' LANGUAGE plpgsql;
\ No newline at end of file