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

[..hidden..]

Revision: 5816
          http://sourceforge.net/p/ledger-smb/code/5816
Author:   ehuelsmann
Date:     2013-05-17 18:50:28 +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 11:17:29 UTC (rev 5815)
+++ trunk/sql/modules/Transaction_Templates.sql	2013-05-17 18:50:28 UTC (rev 5816)
@@ -157,7 +157,8 @@
 delete from recurringprint where id = $5;
 delete from recurring where id = $5;
 insert into recurring (id, reference, startdate, recurring_interval, howmany)
-values ($5, $1, $2, $3, $4);
+values ($5, $1, $2, $3, $4)
+returning *;
 $$;
 
 CREATE OR REPLACE FUNCTION journal__save_recurring_print

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