From 8dbacd96c955f36385f84ed5dd0c534ae982ebb6 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Wed, 8 Oct 2008 01:38:46 +0000 Subject: Correcting bad data type in location_result git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2356 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/modules/Location.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'sql') diff --git a/sql/modules/Location.sql b/sql/modules/Location.sql index ee39ca76..117a53bf 100644 --- a/sql/modules/Location.sql +++ b/sql/modules/Location.sql @@ -157,7 +157,8 @@ CREATE TYPE location_result AS ( city text, state text, mail_code text, - country text + country text, + location_class int ); CREATE OR REPLACE FUNCTION location__get(in_id int) returns location_result AS $$ -- cgit v1.2.3