diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-11-22 03:59:09 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-11-22 03:59:09 +0000 |
| commit | a7badcbfb8db7f379590d66031137efb9f65717c (patch) | |
| tree | 28f71ed65ad68ef8865ec721bbaffaa71ad86660 /sql | |
| parent | 0190093b09369a6fcf50887620a65b242199478e (diff) | |
More customer fixes
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1889 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/modules/Customer.sql | 4 |
1 files changed, 2 insertions, 2 deletions
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; |