summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoreinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-10-08 01:38:46 +0000
committereinhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>2008-10-08 01:38:46 +0000
commit8dbacd96c955f36385f84ed5dd0c534ae982ebb6 (patch)
treef7da409226fa914adeff03e6fd59dec844a9f581
parentf073dc59a9a1323b14c61941661d69ac44e6ce64 (diff)
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
-rw-r--r--sql/modules/Location.sql3
1 files changed, 2 insertions, 1 deletions
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 $$