SF.net SVN: ledger-smb:[5817] trunk/sql/modules/Transaction_Templates.sql

[..hidden..]

Revision: 5817
          http://sourceforge.net/p/ledger-smb/code/5817
Author:   ehuelsmann
Date:     2013-05-17 19:24:16 +0000 (Fri, 17 May 2013)
Log Message:
-----------
Return the values inserted in a function requiring the inserted
row to be returned. Found by Chris Calef.

Modified Paths:
--------------
    trunk/sql/modules/Transaction_Templates.sql

Modified: trunk/sql/modules/Transaction_Templates.sql
===================================================================
--- trunk/sql/modules/Transaction_Templates.sql	2013-05-17 18:50:28 UTC (rev 5816)
+++ trunk/sql/modules/Transaction_Templates.sql	2013-05-17 19:24:16 UTC (rev 5817)
@@ -166,7 +166,8 @@
 RETURNS recurringprint LANGUAGE SQL AS
 $$
 insert into recurringprint (id, formname, format, printer)
-values ($1, $2, 'PDF', $3);
+values ($1, $2, 'PDF', $3)
+returning *;
 $$;
 
 CREATE OR REPLACE FUNCTION journal__increment_recurring

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.