From cb92467b6c9f4a6bd223ee7896cb5ad6ee012c97 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Fri, 8 Aug 2008 05:11:41 +0000 Subject: Adding meta_number to company_billing_info return set git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2242 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/modules/Company.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'sql') diff --git a/sql/modules/Company.sql b/sql/modules/Company.sql index ec530841..ce9723a0 100644 --- a/sql/modules/Company.sql +++ b/sql/modules/Company.sql @@ -247,6 +247,7 @@ $$ language plpgsql; CREATE TYPE company_billing_info AS ( legal_name text, +meta_number text, tax_id text, street1 text, street2 text, @@ -263,7 +264,7 @@ $$ DECLARE out_var company_billing_info; t_id INT; BEGIN - select c.legal_name, c.tax_id, a.line_one, a.line_two, a.line_three, + select c.legal_name, eca.meta_number, c.tax_id, a.line_one, a.line_two, a.line_three, a.city, a.state, a.mail_code, cc.name into out_var FROM company c -- cgit v1.2.3