Correcting all known casting issues relating to PostgreSQL 8.3

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@2071 4979c152-3d1c-0410-bac9-87ea11338e46

1 files changed, 3 insertions, 3 deletions

diff --git a/LedgerSMB/IC.pm b/LedgerSMB/IC.pm
index 04571bb0..09bc0177 100755
--- a/LedgerSMB/IC.pm
+++ b/LedgerSMB/IC.pm
@@ -1899,11 +1899,11 @@ sub create_links {
 			       c3.accno AS expense_accno, 
 			       c3.description AS expense_description
 			  FROM chart c1, chart c2, chart c3 
-			 WHERE c1.id IN (SELECT value FROM defaults 
+			 WHERE c1.id IN (SELECT value::int FROM defaults 
 			 WHERE setting_key = 'inventory_accno_id')
-			       AND c2.id IN (SELECT value FROM defaults
+			       AND c2.id IN (SELECT value::int FROM defaults
 			 WHERE setting_key = 'income_accno_id')
-			       AND c3.id IN (SELECT value FROM defaults
+			       AND c3.id IN (SELECT value::int FROM defaults
 			                      WHERE setting_key 
 			                            = 'expense_accno_id')|;
         $sth = $dbh->prepare($query);