From a7badcbfb8db7f379590d66031137efb9f65717c Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Thu, 22 Nov 2007 03:59:09 +0000
Subject: More customer fixes

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1889 4979c152-3d1c-0410-bac9-87ea11338e46
---
 sql/modules/Customer.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'sql/modules')

diff --git a/sql/modules/Customer.sql b/sql/modules/Customer.sql
index c368906b..500556f5 100644
--- a/sql/modules/Customer.sql
+++ b/sql/modules/Customer.sql
@@ -22,7 +22,7 @@ CREATE TYPE customer_search_return AS (
         taxincluded bool,
         creditlimit numeric,
         terms int2,
-        customernumber int,
+        customernumber text,
         business_id int,
         language_code text,
         pricegroup_id int,
@@ -222,7 +222,7 @@ BEGIN
 	FOR out_row IN
 		SELECT * from entity_bank_account where entity_id = in_entity_id
 	LOOP
-		RETURN NEXT;
+		RETURN NEXT out_row;
 	END LOOP;
 END;
 $$ LANGUAGE PLPGSQL;
-- 
cgit v1.2.3