[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

Revision: 6144
Author:   ehuelsmann
Date:     2013-10-20 14:21:04 +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:

Modified: trunk/sql/upgrade/sl2.8-1.3.sql
--- trunk/sql/upgrade/sl2.8-1.3.sql	2013-10-20 14:19:08 UTC (rev 6143)
+++ trunk/sql/upgrade/sl2.8-1.3.sql	2013-10-20 14:21:04 UTC (rev 6144)
@@ -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,
-  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 >
Ledger-smb-commits mailing list