SF.net SVN: ledger-smb:[6143] branches/1.3/sql/upgrade/sl2.8-1.3.sql

[..hidden..]

Revision: 6143
          http://sourceforge.net/p/ledger-smb/code/6143
Author:   ehuelsmann
Date:     2013-10-20 14:19:08 +0000 (Sun, 20 Oct 2013)
Log Message:
-----------
sl2.8-1.3.sql: add a cast ::int to a null, for psql to be able to
match the function signature.

Modified Paths:
--------------
    branches/1.3/sql/upgrade/sl2.8-1.3.sql

Modified: branches/1.3/sql/upgrade/sl2.8-1.3.sql
===================================================================
--- branches/1.3/sql/upgrade/sl2.8-1.3.sql	2013-10-20 11:20:11 UTC (rev 6142)
+++ branches/1.3/sql/upgrade/sl2.8-1.3.sql	2013-10-20 14:19:08 UTC (rev 6143)
@@ -26,10 +26,11 @@
 SELECT id, accno, description
   FROM sl28.chart WHERE charttype = 'H';
 
-SELECT account_save(id, accno, description, category, gifi_accno, NULL, contra, 
-                    CASE WHEN link like '%tax%' THEN true ELSE false END, 
+SELECT account_save(id, accno, description, category, gifi_accno, NULL::int,
+                    contra,
+                    CASE WHEN link like '%tax%' THEN true ELSE false END,
                     string_to_array(link,':'))
-  FROM sl28.chart 
+  FROM sl28.chart
  WHERE charttype = 'A';
 
 delete from account_link where description = 'CT_tax';

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


------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits