diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-11-25 08:12:12 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-11-25 08:12:12 +0000 |
| commit | afc48e01665120367736ffdbe33ca52252a42704 (patch) | |
| tree | e241d4ef077065fe92d3258dfe606659b9ad81da /sql/modules/Location.sql | |
| parent | 7c9b5fcafe0769499fc7fc3b9bea1365ed82d8d4 (diff) | |
Contact management postfactoring
git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1899 4979c152-3d1c-0410-bac9-87ea11338e46
Diffstat (limited to 'sql/modules/Location.sql')
| -rw-r--r-- | sql/modules/Location.sql | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/sql/modules/Location.sql b/sql/modules/Location.sql index c0d57b51..67d197b3 100644 --- a/sql/modules/Location.sql +++ b/sql/modules/Location.sql @@ -19,7 +19,7 @@ $$ DECLARE out_row RECORD; BEGIN FOR out_row IN - SELECT * FROM country ORDER BY id + SELECT * FROM country ORDER BY name LOOP RETURN NEXT out_row; END LOOP; @@ -124,3 +124,14 @@ BEGIN END; $$ language plpgsql; +CREATE TYPE location_result AS ( + id int, + line_one text, + line_two text, + line_three text, + city text, + state text, + country text, + class text +); + |